Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
Event Schedule for update or insert data every month
Abdul Rahman
7y
311
1
Reply
Hi.. I need to run the update query on every month first date. i tied to use event scheduler
but is not working in mysql. please give some ideas.
DELIMITER $$
CREATE EVENT er
ON SCHEDULE every 1 Month
starts '2017-04-13 00:02:00'
DO BEGIN
END$$
DELIMITER ;
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
How to Get the Last Record from SQL Table
Group by with order by error