MySQL gives error in creating MySQL-Events

Question

I am trying to create one MySQL event which updates the table at every midnight. My query is like this:

CREATE EVENT postdetails_change_status 

ON SCHEDULE EVERY 1 DAY STARTS '2014-04-21 00:00:00'

DO BEGIN

    UPDATE postdetails SET status = 'completed' WHERE DeleteDate < CURDATE();

END;

This gives me error like enter image description here

But when I run this update query normally, it works perfectly. Please help.

Reference: http://www.sitepoint.com/how-to-create-mysql-events/

Ronak Shah · Accepted Answer · 2014-04-21 04:31:22Z

1

Your script is correct but just change delimiter before script execution. try below:

delimiter |

CREATE EVENT postdetails_change_status 

ON SCHEDULE EVERY 1 DAY STARTS '2014-04-21 00:00:00'

DO BEGIN

    UPDATE postdetails SET status = 'completed' WHERE DeleteDate < CURDATE();

END |

delimiter ;

answered Apr 21, 2014 at 4:31

Ronak Shah

1,5592 gold badges13 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

MySQL gives error in creating MySQL-Events

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related