CREATE EVENT event_add_table_partition
ON SCHEDULE EVERY 1 MONTH STARTS DATE_ADD(DATE_SUB(DATE_ADD(DATE_SUB(CURDATE(),INTERVAL DAY(CURDATE())-1 DAY), INTERVAL 1 MONTH),INTERVAL 1 DAY),INTERVAL 1 HOUR)
ON COMPLETION PRESERVE ENABLE
COMMENT '每月最后一天01:00执行'
DO
CALL add_table_partition();
Mysql event
最新推荐文章于 2024-08-07 16:37:16 发布