MySQL Forums
Forum List  »  General

Has anyone used "event" in mysql
Posted by: Christine Sun
Date: November 03, 2010 07:37PM

I have not seen "event" in MS SQL, so when I saw it in MySQL doc's, I was excited.
However it is not working for me.
I tried the following:

Create event event_name
On schedule at current_timestamp + interval 1 minute
do
update table1 set column1 = column1 + 1

The event would show up if you use 'show events;',
but after 1 minute, column1 of table1 has no change.

Anyone has a clue? Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Has anyone used "event" in mysql
November 03, 2010 07:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.