Troubleshooting MySQL Event for Daily Table Reset
DELIMITER $$ CREATE EVENT reset_daily_learning_info on schedule every 1 day STARTS CURRENT_TIMESTAMP DO BEGIN UPDATE daily_learning_info SET studied = 0, amount = 0; END; DELIMITER ; This is my mysql event, it should reset a table named “daily_learning_info” in everyday. But it doesn’t do that. I don’t know the problem. How can I resolve this? […]