Concluído

MYSQL Trigger

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

Habilidades: MySQL

Veja mais: mysql trigger after update, mysql trigger before update, mysql trigger for each row, mysql trigger before insert, mysql trigger after insert, mysql trigger after insert or update, mysql trigger if, mysql trigger if statement, Hi there, I need some business card design urgently. If you think you are best candidate for this project please tell me somethi, Hi there, I need $90, Hi Guys, I need a square banner for promotion in facebook and instagram, The banner has to have a very good fonts, please be c, i need write a appraisal to my company, i can write but need an illustrator in uk, hi i need to do a keygen for my software, hi i need to configure freepbx and asterisk upon a project we have really quick and easy stuff thanks

Acerca do Empregador:
( 7 comentários ) Nashik, India

ID do Projeto: #16980147

Concedido a:

rushank

Hi , Greetings ! As we have discussed in private message about this new task and mysql trigger. Thanks, Rushank

₹1000 INR em 1 dia
(5 Comentários)
2.5

7 freelancers estão ofertando em média ₹1436 para esse trabalho

schungur

ONE OF THE TOP SQL FREELANCERS REGARDING MY SQL LEVEL 3 BADGE,.... Please check my badge,s projects and reviews...

₹1750 INR em 1 dia
(16 Comentários)
4.7
tausy

A proposal has not yet been provided

₹2250 INR em 1 dia
(1 Comentário)
2.1
sourabhmalani3

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 recor Mais

₹600 INR em 1 dia
(1 Comentário)
1.5
raneemmazen

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 lan Mais

₹1850 INR in 5 dias
(0 Comentários)
0.0
nsoni755

A proposal has not yet been provided

₹1300 INR em 1 dia
(0 Comentários)
0.0
Sreelekhakomma24

I learnt MySQL very perfect and I am good at database

₹1300 INR in 5 dias
(0 Comentários)
0.0