MySQL Forums
Forum List  »  Triggers

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

Hi,

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


Thanks,
Jassim

Options: ReplyQuote


Subject
Views
Written By
Posted
How to long previous record?
238
October 26, 2019 07:10AM
83
October 26, 2019 12:25PM


Sorry, only registered users may post in this forum.

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.