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 ;