mysql创建事件

/*开启功能*/

SET GLOBAL event_scheduler = ON;

 

DELIMITER //

DROP EVENT IF EXISTS `eventomstatics`;

CREATE    EVENT IF NOT EXISTS `eventomstatics`

 

ON SCHEDULE

EVERY 1 DAY 

 STARTS TIMESTAMP(CURRENT_DATE,'23:00:00')

 ON COMPLETION PRESERVE ENABLE

DO call PRO_SUM_OMSTATICS_DAY()

//

DELIMITER ;

 

 

SELECT * FROM information_schema.EVENTS;

 

SELECT * FROM information_schema.EVENTS;