3

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END$$ DELIMITER' at 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
0

2 Answers 2

3

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 ;
Sign up to request clarification or add additional context in comments.

1 Comment

no , it's still wrong. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER;' at line 1
0
     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";

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.