alertfrancis Ответов: 0

Как заставить create event работать во время выполнения в mysql


I am working on a social network were users create a post But this post is not permanent so the user have to set the duration of time they want the post to be seen but i can't use create event on runtime, I have this code to test creating event that will insert a row into my db in 10 second but it is not working on runtime but when i use the same code in my phpmyadmin environment it will work fine i have been trying to figure it out but not yet please i need help.


Что я уже пробовал:

<pre>DELIMITER |
  CREATE EVENT stop_fad_1 ON SCHEDULE 
    AT CURRENT_TIMESTAMP + INTERVAL 10 SECOND 
    ON COMPLETION PRESERVE 
  DO 
  BEGIN
   insert into hide_fad(userid,fad_id)values(11,38);
    END |
    DELIMITER ; 

0 Ответов