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.