Clever Geek Handbook

MySql Error CREATE EVENT

1064 - You have an error in your SQL syntax; check the manual corresponding to your MySQL server version for the correct syntax to use next to "END $$ DELIMITER" on line 4

CREATE EVENT event_1 ON SCHEDULE EVERY 1 WEEK STARTS CURRENT_DATE + INTERVAL 6 - WEEKDAY(CURRENT_DATE) DAY DO BEGIN 
UPDATE 
    sonice_User 
SET 
    update_chance = "1"; END
+3


source to share


2 answers 


     CREATE EVENT event_1 ON SCHEDULE EVERY 1 WEEK 
     STARTS CURRENT_DATE + INTERVAL 6 - WEEKDAY(CURRENT_DATE) DAY
     DO 
     UPDATE   sonice_User 
     SET update_chance = "1";


0


source


use below code:



 Delimiter $$
 CREATE EVENT event_1 ON SCHEDULE EVERY 1 WEEK 
     STARTS CURRENT_DATE + INTERVAL 6 - WEEKDAY(CURRENT_DATE) DAY
     DO 
     BEGIN
     UPDATE   sonice_User 
     SET update_chance = "1";
     END $$
 Delimiter ;
+3


source






More articles:


All Articles