Triggeri ei toimi: Can't update table 'GPS' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
Ei toimi koska: A stored function or trigger cannot modify a table that is already being used (for reading or writing) by the statement that invoked the function or trigger. (https://dev.mysql.com/doc/refman/5.6/en/stored-program-restrictions.html)
Mahdollisina vaihtoehtoisina toteutus vaihtoehtoina ainakin EVENT ja proseduuri
Triggeri ei toimi:
Can't update table 'GPS' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.Ei toimi koska:
A stored function or trigger cannot modify a table that is already being used (for reading or writing) by the statement that invoked the function or trigger.(https://dev.mysql.com/doc/refman/5.6/en/stored-program-restrictions.html)Mahdollisina vaihtoehtoisina toteutus vaihtoehtoina ainakin EVENT ja proseduuri