Problem running event with Mysql

Asked

Viewed 101 times

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?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.