MySQL Forums
Forum List  »  Triggers

Trigger....pls help
Posted by: raji
Date: February 18, 2005 03:32AM

Hi all...

Im using MySQL 5.0.2 and I would like to write a trigger that will store only the most recent 20 records in th table. The older records should be flushed as an when the new ones come in.
Pls give me some examples for deleting records using triggers.......

Waiting for ur response

Thank u
Regards
Raji

Options: ReplyQuote


Subject
Views
Written By
Posted
Trigger....pls help
3000
February 18, 2005 03:32AM
2507
February 18, 2005 03:45PM
2484
March 03, 2005 08:28AM


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.