Triggers now work (it's official)

[Andrew Gilfrin]

Hi All,

As you may know I had a good fiddle with triggers while writing content for my site. I came to the conclusion that they were next to useless at the time (5.0.3) as you couldn't do a great deal with them back then, let alone the total absence of meta data.

There have been a number of updates since then but I left well alone as they seemed far to messy to be of any practical use (Jay Pipes did some great work in the area).

But when I heard that meta data had been included for triggers in 5.0.10 and also that the lock tables requirement had been lifted I upgraded straight away. Seems to work great on my Mac OS X machine.

I'm updating my tutorials as we speak to reflect the new changes. Thanks to all the developers at MySQL who have made triggers worth using.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information