jojacafe
7/18/2017 - 11:56 AM

Mysql Scheduled Events http://www.9lessons.info/2012/10/mysql-event-scheduler.html https://www.sitepoint.com/working-with-mysql-events/

Mysql Scheduled Events

http://www.9lessons.info/2012/10/mysql-event-scheduler.html https://www.sitepoint.com/working-with-mysql-events/

event procedure every day.sql
content_copyfile_download
SHOW PROCESSLIST;

SET GLOBAL event_scheduler = ON;

SHOW EVENTS;

CREATE EVENT BigDataHouse
ON SCHEDULE EVERY 1 DAY
STARTS '2017-07-18 23:59:00'
DO
call bigdata.new_procedure();

ALTER EVENT BigDataHouse
DO
call bigdata.bigdataHouse();

SELECT * FROM INFORMATION_SCHEMA.EVENTS;