Mysql event doesn't run

Asked Jul 07 '18 at 15:17

Active Jul 07 '18 at 15:19

Viewed 99 times

I am trying to set an event in my Mysql database that will run every minute to update a table. This is my code I put to run:

UPDATE credit SET daily ='1000' WHERE Id=1

This is the message I get after I set the event

CREATE DEFINER=`xxx_knxxc`@`localhost` EVENT `zero_column`
ON SCHEDULE EVERY 1 MINUTE STARTS '2018-07-07 14:49:00'
ON COMPLETION NOT PRESERVE ENABLE
DO UPDATE credit SET daily ='1000' WHERE Id=1

edited Jul 07 '18 at 15:19

Raymond Nijland

11,488
2
22
34

asked Jul 07 '18 at 15:17

LoveDroid

"This is the message I get after I set the event" Your message is the SQL code what is the real message/error? – Raymond Nijland Jul 07 '18 at 15:20
There is no error message, the message I get after is what I see after I set the event. I put my code in the definition field and the rest parameters i select from dropdown lists – LoveDroid Jul 07 '18 at 15:26
Do you see it if you do `SHOW EVENTS`? – Barmar Jul 07 '18 at 15:49
Did you enable the event scheduler? Try `SELECT @@event_scheduler;` to see if it's enabled. – Bill Karwin Jul 07 '18 at 16:00

Mysql event doesn't run

0 Answers0