CREATE DEFINER = 地址 EVENT 事件名
ON SCHEDULE EVERY 1 DAY STARTS ‘2016-03-08 00:00:00’ ON COMPLETION PRESERVE ENABLE DO
UPDATE cus_base b
SET b.protectio = NULL,
b.expiration_date = NULL
WHERE
b.expiration_date <= now()
mysql定时器
最新推荐文章于 2024-04-21 15:13:44 发布