>
> 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
--- Original Message ---
> From: viraj
> 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 becau
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 t