Hi dears
I need to write a trigger for one my MYSQL Tables.
This table is called SLC
This SLC table has some fields as follows
aux1,aux2,aux3,aux4,aux5,aux6,aux7,aux8,r_failure,y_failure,b_failure
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
Hi there,
I read this job's description and understand that.
As per initial requirement need to create trigger on table. In trigger need to check if values of any of speciefied column is changed then insert record into another table before update this.
I assure for the quality work and fulfill of the work requirement. I will provide full support related to given work if needed later.
I would be glad to discuss project with you. I'm looking for positive response from your end.
I will complete this work within time frame.
Thank you for your time.
With Regards,
Sourabh Malani
hello there,
I am Raneem and it will be my pleasure to work with you.
I have an outstanding experience in both frontend and backend development and a good knowledge of PHP so I can handle any website using this language. If you want I can share some links with you after getting my clients' approval.
Thank you for your time and I wish we can work together.
Regards,
Raneem