Problem running event with MySQL

1

Hey guys, all right? I have a question, I have 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 clean the table that writes the sessions of the clients that have items in their shopping cart every 10 minutes, but if I execute only the DELETE ... it executes but the event does not, I enabled in my PhpMyAdmin the event scheduler it's nothing. What is missing?

    
asked by anonymous 20.11.2018 / 13:35

0 answers