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.
In real situation, i am not calculation the area and volume. I am doing production monitoring which base on every seconds. Production Target compare with actual production will run simultaneously. Target = (current time - start time)/cycle time of production. Therefore every 5 sec i will update my database.