Re: Help for newbie to triggers

[Greg Johll]

Thanks for the reply, but now I have doubts that I can even do what I want with this trigger.

From the article:
http://dev.mysql.com/tech-resources/articles/mysql-triggers.pdf

"But remember that functions are subject to severe limitations: you cannot access tables from within a function. So these statements are illegal inside a function:

ALTER 'CACHE INDEX' CALL COMMIT CREATE DELETE DROP 'FLUSH PRIVILEGES' GRANT INSERT KILL LOCK OPTIMIZE REPAIR REPLACE REVOKE ROLLBACK SAVEPOINT 'SELECT FROM table' 'SET system variable' 'SET TRANSACTION' SHOW 'START TRANSACTION' TRUNCATE UPDATE

Precisely the same limitation applies for triggers."

So my attempt to DELETE from another table is not possible from a trigger. Correct?

Thanks,
Greg