I have the following Trigger
DROP TRIGGER IF EXISTS test; CREATE TRIGGER test BEFORE UPDATE ON traco_activities FOR EACH ROW INSERT INTO bitacora_tarifas(fecha) VALUES (NOW())
but it does not work, and I got it the following error:
1442-Can´t update table 'bitacora_tarifas' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
the structure of the table bitacora_tarifas is the next:
id, mediumint fecha, datetime
The "id" is autoincrement i tried :
FOR EACH ROW INSERT INTO bitacora_tarifas(id,fecha) VALUES (0,NOW())
but anyways it does not work....
Someone can help me?
Aucun commentaire:
Enregistrer un commentaire