MySql event not updating table column
I am trying to run an event on my localhost (I have never used events before), and I can't get it to work. Given what I have read, my event should work. I have tested the SQL it needs to execute and it works perfectly, so it has to be the event that is broken. I set the event to occur every one minute but still had no luck. What I want it to do is set the value of the column 'numOrders' where 'get' is 'orders' to 0. This needs to happen at the beginning of every day. Please advise.
DROP EVENT IF EXISTS `dailyreset`; CREATE DEFINER=`root`@`localhost` EVENT `dailyreset` ON SCHEDULE EVERY 1 DAY STARTS '2021-04-23 00:01:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE orderstoday SET numOrders='0' WHERE get='orders'