MySQL Forums
Forum List  »  Triggers

2 questions - delete and old?
Posted by: Lee Jackson
Date: July 25, 2005 09:04AM

Hi,
Ive been playing around with triggers in order to provide an audit trail for one of our apps. Ive 2 problems though :-

1) When data is inserted or updated I can use new.field to get new value the value. If a field is to be updated or deleted how do I get at the old/original value? (old.field? Didnt seem to work....)

2) Possibly related to my ignorance of the above my before delete trigger seems to hang - is there anything special I should know about deletion and triggers?

Any help appreciated

Lee

Options: ReplyQuote


Subject
Views
Written By
Posted
2 questions - delete and old?
3373
July 25, 2005 09:04AM


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.