MySQL trigger

[Lihis]

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