That is correct. There is as far as I know no way in a MySQL trigger to
neither to do operations on the table the trigger belongs to (obviously
except the row that the trigger is operating on through the NEW variables)
nor reject an insert, update, or delete.
thanks jesper.
~viraj
It
i have two table, T1, T2. and 1 trigger.
trigger is before update on T1 and it updates some values in T2. once
it's done, the trigger tries to delete the subject row of T1 (delete
from T1 where id = new.id)
i tried with second trigger on T2 (after/before update) and with a
procedure inside this
--- Original Message ---
From: viraj kali...@gmail.com
To: mysql@lists.mysql.com
Sent: 19/2/10, 05:48:41
Subject: ERROR 1442 (HY000) when delete inside trigger statement
issue: ERROR 1442 (HY000): Can't update table 'T1' in stored
function/trigger because it is already used