troubleshooting Question

Trigger function in MySQL

Avatar of Rama Tito
Rama TitoFlag for Malaysia asked on
3 Comments1 Solution67 ViewsLast Modified:
Trigger in MySQL. I am trying to create trigger in mysql  for every incoming data from remote device. Example i will receive data from remote device the Length and Width - value in integer datatype, therefore the trigger function will calculate the Area and Volume and update the row. I do manage to do this. The question is as follows : -

If no incoming data from remote device, i would like to trigger every 5 sec and calculate the Area and Volume with default value. If data come in from remote device then i have to reset the 5 sec from zero. As thought as a watch dog.
Database Analyst
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros