MySQL Forums
Forum List  »  Triggers

Re: trigger to copy complete row
Posted by: Bob Field
Date: August 30, 2006 09:32AM

CREATE TRIGGER erase 
BEFORE DELETE ON table_a 
FOR EACH ROW 
INSERT INTO table_b SELECT new.*;

Options: ReplyQuote


Subject
Views
Written By
Posted
14563
August 30, 2006 01:54AM
Re: trigger to copy complete row
6988
August 30, 2006 09:32AM
7989
August 30, 2006 10:27PM
5169
August 30, 2006 10:44PM


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.