Debug a MYSQL trigger and stored procedure
₹600-1500 INR
Pago na entrega
Hi dears
I Need a MYSQL Database Expert to debug a trigger and stored procedure.
History:
I have one table called slc. This is an OLTP table. Data keeps on getting inserted into this table every couple of minutes. It is a data for streetlighting. Street lights send 2 types of data viz
1) switching data: this is a data they send when they are on/off.
2) faults data: this is the data they send when they generate faults.
Problem statment: There is a trigger and stored procedure to check in SLC table that if the switching data/faults data is changed from the previous record, then insert that record in SLCEvents table.
But currently wrong data is inserted in the slcevents table.
Can anyone help with this?
thanking you in advance
ID do Projeto: #17111462
Sobre o projeto
11 freelancers estão ofertando em média ₹1516 nesse trabalho
Hi, I have good proficiency in sql. Available to start now. Get in touch to discuss more. Regards, Manish
Hi, I am a database developer more than 5 years. I use oracle and MYSQL for projects extensively. Please let me know your code, let me analyse and will provide solution. Thanks Paul
Hi, Please view my profile. I have 8 years experience in SQL, MySql, PHP, SSRS. Please let me know more details. Sky pe : ujasdubal
Hi. I have a lot of experience with Oracle, MySQL and SQL Server procedures, triggers, etc. Please share scripts and tables with me and I will check it
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience. I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing Mais