MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Trigger....pls help
3000
raji
February 18, 2005 03:32AM
Re: Trigger....pls help
2505
Federico Razzoli
February 18, 2005 03:45PM
Re: Trigger....pls help
2482
Andrew Gilfrin
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.