Debug a MYSQL trigger and stored procedure

Encerrado Postado há 5 anos Pago na entrega
Encerrado 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

Administração de Bancos de Dados MySQL PHP Arquitetura de software SQL

ID do Projeto: #17111462

Sobre o projeto

11 propostas Projeto remoto Ativo em há 5 anos

11 freelancers estão ofertando em média ₹1516 nesse trabalho

softcarve

Hi, I have good proficiency in sql. Available to start now. Get in touch to discuss more. Regards, Manish

₹1300 INR em 1 dia
(81 Comentários)
6.0
paulprabhakarand

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

₹3000 INR em 1 dia
(20 Comentários)
4.7
ujasdubal

Hi, Please view my profile. I have 8 years experience in SQL, MySql, PHP, SSRS. Please let me know more details. Sky pe : ujasdubal

₹999 INR em 1 dia
(7 Comentários)
2.5
nubelo_MjFSuBpQ

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

₹1300 INR in 10 dias
(2 Comentários)
2.0
cmnayal

Over 11 years of IT industry experience and specializes in application development using Microsoft SQL Server 2014/2012/ SQL 2008 R2, Microsoft SQL Server Business Intelligence platform, Microsoft SharePoint 2010/2013 Mais

₹1250 INR em 1 dia
(0 Comentários)
0.0
sunilmudunuri

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

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