MySQL: Help with Event

[RaidenLeeChin]

Hey all, 

I tested this and i believe it works but i think it may be wrong.

Can anyone skilled in creating events help me correct the code. Thanks!

 

What i want to achieve:
It updates a field (flag) in a table (mytable) with a value of 0 after a certain time (6 hours and 10 minutes from when it was created) then removes itself from the scheduler. So i click a button, it creates the event and after 6 hours and 10 minutes the event sets flag = 0 and removes itself.

 

Code:

CREATE EVENT myevent ON SCHEDULE EVERY 6 HOUR STARTS CURRENT_TIMESTAMP + INTERVAL 6 HOUR + INTERVAL 10 MINUTE ENDS CURRENT_TIMESTAMP + INTERVAL 6 HOUR + INTERVAL 11 MINUTE DO UPDATE mytable SET flag = 0

 

[FastBehindYou]

Why do you think it is wrong, if it works?

[RaidenLeeChin]

Why do you think it is wrong, if it works?

 

I am using it on a client server and he insists that it does not stay for 6 hrs and 10 min but i tested it on my local server and it works.

I just want someone to review it and see if the syntax is correct.

[madknight3]

I am using it on a client server and he insists that it does not stay for 6 hrs and 10 min but i tested it on my local server and it works.

I just want someone to review it and see if the syntax is correct.

 

Are you able to test it on their server?

[RaidenLeeChin]

Are you able to test it on their server?

 

At the moment no. Just need someone to see if the sytax is correct.

[Neil]

Versions of MySQL running on your server and his?

 

Are the schemas the same?

How is this being added?

[RaidenLeeChin]

Versions of MySQL running on your server and his?

 

Are the schemas the same?

How is this being added?

 

Php and database schema are the same.

I am using the codeigniter framework so when a form gets submitted the code is executed directly on the db.

So there is nothing wrong with the code?