mysql eventタイミングタスクの作成
331 ワード
CREATE EVENT `job_commodity_status`
ON SCHEDULE EVERY 1 DAY -- [HOUR|MONTH|WEEK|DAY|MINUTE|...]
STARTS '2017-03-21 22:10:00' --
ON COMPLETION NOT PRESERVE -- ,job
ENABLE --
DO --
CALL `ecommerce_job_commodity_status`(); --