MySQL Forums
Forum List  »  Triggers

How to long previous record?
Posted by: Jassim Rahma
Date: October 26, 2019 07:10AM


I have a table: channels

and another table: history_channels

The only difference is one field called log_status which logs the status in the history_channels with N if New, Edit if Edited and D if Deleted

How can i create a trigger to copy..

1. The new record when added
2. The record before edit
3. the record before delete

without having to mention all the fields but just the log_status as well as log_date and log_ip


Options: ReplyQuote

Written By
How to long previous record?
October 26, 2019 07:10AM
October 26, 2019 12:25PM

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.