MySQL Forums
Forum List  »  Triggers

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

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


Options: ReplyQuote

Written By
2 questions - delete and old?
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.