1
Eai guys, all right? I’m having a doubt, I set up the following SQL
CREATE DEFINER = `root`@`localhost` EVENT `ut_clear_cart`
ON SCHEDULE EVERY
1 MINUTE STARTS '2018-11-20 00:00:00'
ON COMPLETION NOT PRESERVE ENABLE
DO
DELETE
FROM
ut_cart_storage
WHERE
updated_at >= NOW() - INTERVAL 10 MINUTE
To clear the table that records the sessions of customers who have items in their shopping cart every 10 minutes, but if I run only DELETE ... it runs but the event does not, I enabled in my Phpmyadmin the Event Scheduler and nothing. What is missing?