在指定时间执行sql
CREATE EVENT e_test ON SCHEDULE AT TIMESTAMP '2010-09-15 22:35:00' DO update user SET V = 'ABC' WHERE id = 7;
前提是:
SET GLOBAL event_scheduler = 1;
其他用法
http://hzl7652.iteye.com/blog/614263
CREATE EVENT e_test ON SCHEDULE AT TIMESTAMP '2010-09-15 22:35:00' DO update user SET V = 'ABC' WHERE id = 7;
前提是:
SET GLOBAL event_scheduler = 1;
其他用法
http://hzl7652.iteye.com/blog/614263