MYSQL 事件

CREATE DEFINER=`root`@`%` EVENT `test`
ON SCHEDULE EVERY 1 SECOND STARTS '2012-09-30 17:00:00' 
ON COMPLETION NOT PRESERVE ENABLE
DO call nested_tfer_funds;

 

nested_tfer_funds 为存储过程

SELECT * FROM information_schema.global_variables WHERE variable_name LIKE 'event_scheduler';
SHOW VARIABLES LIKE 'event_scheduler';
SHOW GLOBAL VARIABLES LIKE 'event_scheduler';

SET GLOBAL event_scheduler=1;