Has anyone used "event" in mysql
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.
Subject
Written By
Posted
Has anyone used "event" in mysql
November 03, 2010 07:37PM
November 03, 2010 08:11PM
November 03, 2010 08:22PM
November 03, 2010 08:27PM
November 03, 2010 08:55PM
November 03, 2010 09:56PM
November 03, 2010 10:56PM
November 03, 2010 11:57PM
November 04, 2010 09:12AM
November 03, 2010 08:55PM
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.