1
350CREATE EVENT e_hourly
ON SCHEDULE
EVERY 1 HOUR STARTS ‘ 2007-02-10 23:59:00 ‘ ENDS ‘ 2008-02-10 23:59:00 ‘
DO
DELETE FROM messages limit 10;
可以帮我写一下 每周三的 00:00 新增一条数据 怎么写时间部分
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
收藏
CREATE EVENT e_hourly ON SCHEDULE EVERY 4 WEEK STARTS '2015-09-07 02:00:00' ON COMPLETION PRESERVE DISABLE ON SLAVE DO BEGIN
INSERT INTO xxx(A,B,C) values('1','2','3');
END