MySQL Forums
Forum List  »  Events (Job Scheduler)

Event, check for each row?
Posted by: nf damh
Date: August 22, 2007 01:18AM

Hi all,

can event be scheduled to check each row in a table at specific time?

create table AA
(AA_id int(2) not null auto_increment,
AA_date data,
primary key(AA_id));

I want to create an event that check each row in a table AA every day at 12.00am. If AA_date is 2 weeks old, then it will be insert into table BB.

Can it be achieved using event or i should use triggers n stored procedure. I hope someone can give me some ideas..

Options: ReplyQuote

Written By
Event, check for each row?
August 22, 2007 01:18AM
August 24, 2007 01:48PM

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.