MySQL Forums :: General :: Has anyone used "event" in mysql


Advanced Search

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 Christine Sun 11/03/2010 07:37PM
Re: Has anyone used "event" in mysql Barry Galbraith 11/03/2010 08:11PM
Re: Has anyone used "event" in mysql Christine Sun 11/03/2010 08:22PM
Re: Has anyone used "event" in mysql Barry Galbraith 11/03/2010 08:27PM
Re: Has anyone used "event" in mysql Christine Sun 11/03/2010 08:55PM
Re: Has anyone used "event" in mysql Barry Galbraith 11/03/2010 09:56PM
Re: Has anyone used "event" in mysql Christine Sun 11/03/2010 10:56PM
Re: Has anyone used "event" in mysql Barry Galbraith 11/03/2010 11:57PM
Re: Has anyone used "event" in mysql Christine Sun 11/04/2010 09:12AM
Re: Has anyone used "event" in mysql Christine Sun 11/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.