MySql CREATE EVENT Error

Question

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

user5026754 · Accepted Answer · 2015-07-25 04:09:45Z

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 ;

answered Jul 25, 2015 at 4:09

user5026754

Sign up to request clarification or add additional context in comments.

1 Comment

IDTIMW Over a year ago

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

Abhishek · Accepted Answer · 2015-07-25 04:03:56Z

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";

answered Jul 25, 2015 at 4:03

Abhishek

4,8094 gold badges29 silver badges39 bronze badges

Collectives™ on Stack Overflow

MySql CREATE EVENT Error

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

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related