mysql 定时器的使用

1.表结构

CREATE TABLE `timer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

2.创建定时器

CREATE EVENT IF NOT EXISTS e_add
ON SCHEDULE EVERY 5 SECOND
DO
INSERT INTO timer (date) VALUE (now())

3.查看定时器

 show EVENTS

4.开启定时器

set GLOBAL event_scheduler=1

5.查看定时器是否开启

 show VARIABLES like "%event_scheduler%"

6.执行效果