一、demo脚本
DROP EVENT IF EXISTS `update_modenity_num`;
delimiter ||
CREATE EVENT `update_modenity_num` ON SCHEDULE EVERY 1 DAY STARTS '2023-02-09 00:30:00' ON COMPLETION NOT PRESERVE ENABLE DO
UPDATE ld_modentity_num
SET
start_id ='1',
cur_id = '1'
WHERE active = 1
AND reset_value = 'yes'
AND (
CASE
WHEN datetype LIKE '%dd%' THEN 1=1
WHEN datetype LIKE '%mm%' AND DAY(NOW())=1 THEN 1=1
END);
||
delimiter;