MySQL Forums
Forum List  »  Triggers

Re: before delete trigger to make backup of deleted data
Posted by: John Simons
Date: May 10, 2006 12:37PM

Thanks. Typo on my part here. But what syntax can I use for the "values" part of the insert to ensure I insert the appropriate deleted row information?

create trigger hellox before delete on hello
for each row
insert into hello_deleted_data (x,y,z)
values (???.x, ???.y, ???.z); <-- ??

Thanks VERY much!
John



Edited 3 time(s). Last edit at 05/10/2006 02:56PM by John Simons.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: before delete trigger to make backup of deleted data
6709
May 10, 2006 12:37PM


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.