mysql定时任务demo 桃扇骨 2022-06-11 05:16 161阅读 0赞 /\*开启事件\*/ 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
还没有评论,来说两句吧...