MYSQL有EVENT SET GLOBAL event_scheduler = 1; OR SET GLOBAL event_scheduler = ON; 示例: CREATE EVENT e_test ON SCHEDULE AT TIMESTAMP '2007-12-05 12:00:00' DO update test set flag=1;
MYSQL 5.1才有EVENT,只有用windows的任务计划 + 执行代码.bat这种方式了 mysql -u root -p123 testdb "trunate table a; inser a select * from b; delete from out where id in (select * from a or将SQL单独存为文件 mysql -uroot -p*** database < aaa.sqL
SET GLOBAL event_scheduler = 1;
OR
SET GLOBAL event_scheduler = ON;
示例:
CREATE EVENT e_test ON SCHEDULE AT TIMESTAMP '2007-12-05 12:00:00' DO update test set flag=1;
1 把你要执行的sql语句写到D:\1.sql文件里
2 建个.bat文件,里面写mysql -uroot -p123456 <D:\1.sql
3 任务计划调用.bat文件
mysql -u root -p123 testdb "trunate table a; inser a select * from b; delete from out where id in (select * from a or将SQL单独存为文件
mysql -uroot -p*** database < aaa.sqL
http://topic.csdn.net/u/20091020/22/c51bb709-6dbc-4fd1-b874-077714ed547e.html