MYSQL Trigger

₹600-1500 INR

Selesai

Dibuat

hampir 6 tahun yang lalu

₹600-1500 INR

Dibayar ketika dikirim

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

MySQL

ID Proyek: 16980147

Tentang proyek

7 proposal

Proyek remot

Aktif 6 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan kepada:

@rushank

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

₹1.000 INR dalam 1 hari

5,0

(5 ulasan)

2,5

7 freelancer menawar dengan rata-rata ₹1.436 INR untuk pekerjaan ini

@schungur

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

₹1.750 INR dalam 1 hari

5,0

(16 ulasan)

4,7

@tausy

A proposal has not yet been provided

₹2.250 INR dalam 1 hari

5,0

(1 ulasan)

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

₹600 INR dalam 1 hari

5,0

(1 ulasan)

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

₹1.850 INR dalam 5 hari