MySQL Forums
Forum List  »  Triggers

Re: Trigger....pls help
Posted by: Federico Razzoli
Date: February 18, 2005 03:45PM

Something like:

CREATE TRIGGER my_trigger
AFTER INSERT
ON my_table
DELETE FROM my_table ORDER BY creation_time LIMIT 10 OFFSET 19

Not sure this syntax is right, so check it and debug it if it contains errors.

Options: ReplyQuote


Subject
Views
Written By
Posted
2866
February 18, 2005 03:32AM
Re: Trigger....pls help
2433
February 18, 2005 03:45PM
2402
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.