Re: INSERT and DELETE on trigger

[Andrew Gilfrin]

I tried in 5.0.3 and it compiled but then on running a update statement that fires the trigger I shows a warning , ERROR 1064.

Check the line after you run your insert statement

Query OK, 1 row affected, 1 warning (0.00 sec)

If it has 1 warning then run

show warnings;

This will show the message associated with the warning.

I also got

ERROR 1100 (HY000): Table 'dept' was not locked with LOCK TABLES

So I think it's safe to say while it might look like the code compiles it's best to avoid SQL in triggers at present.

Andrew Gilfrin
http://www.mysqldevelopment.com