I need to write a trigger for one my MYSQL Tables.
This table is called SLC
This SLC table has some fields as follows
The trigger would do the following -
when any of these values changes, it will copy the entire record and insert it in a table called
SLCEvents. This table will be exact replica of SLC but with few extra fields as follows -
OriginalEventId = [login to view URL]
IsAlertProcessed = 0 (by default)
But there is a catch here. The trigger should only insert a record in SLCEvents only and only if any or combination of parameter changes from the last record that is inserted.
Can anyone help?
Many thanks in advance