ALTER EVENT reset_monthly
ON SCHEDULE
EVERY 1 MONTH
STARTS '2019-01-01 00:00:00'
COMMENT 'Descriptive comment'
DO
TRUNCATE sequence_code_os;
This event fails to delete all rows of sequence_code_os monthly. Why ?
Asked
Active
Viewed 64 times
0
Barmar
- 741,623
- 53
- 500
- 612
Rafael Áquila
- 23
- 3
-
Does it work if you run the `TRUNCATE` command by hand? – Barmar Feb 25 '19 at 23:44
-
1Is your event scheduler running? See https://stackoverflow.com/questions/942354/why-this-mysql-event-cant-get-run/942411#942411 – Bill Karwin Feb 25 '19 at 23:44
-
TRUNCATE might fail if you have any foreign keys in your table (even if there are no actual dependencies at the moment). Try disabling them during the command if the other alternatives don't work – Ayrton Feb 25 '19 at 23:59
-
Or replace it with `DELETE FROM sequence_code_os;` – Barmar Feb 26 '19 at 00:04
-
It worked. Event scheduler was not running – Rafael Áquila Feb 27 '19 at 11:04