mysql定时任务demo

/*开启事件*/
set global event_scheduler = on;
/*查看事件是否开启*/
show variables like 'event_scheduler';
/*创建表*/
CREATE TABLE `test_sche` (
  `id` int(11) NOT NULL,
  `counts` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*添加数据到表里面*/
INSERT INTO `test_sche` VALUES ('1', '188');


/*创建一个存储过程*/
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `add`()
BEGIN
UPDATE test_sche SET counts=counts+1 WHERE id=1;
END
;;
DELIMITER ;


/*创建一个事件，并调用存储过程*/
CREATE DEFINER=`root`@`localhost` EVENT `test_sche_event`
ON SCHEDULE EVERY 5 SECOND STARTS '2017-06-28 13:16:50'
ON COMPLETION NOT PRESERVE ENABLE
DO CALL `add`


/*查看事件运行状态*/
select * from mysql.event