« Getting to Know Sendmail | Main | Tufts OpenCourseWare Goes Live »
July 28, 2005
MySQL 5.0.10 beta Fixes Significant Trigger Issues
Delighted to see that the release of MySQL 5.0.10 brings the following changes to triggers in MySQL (from the release notes):
- An extension to the SHOW command has been added: SHOW TRIGGERS
can be used to view a listing of triggers. - The INFORMATION_SCHEMA database now includes a TRIGGERS table.
- It is no longer necessary to issue an explicit LOCK TABLES for any
tables accessed by a trigger prior to executing any statements that
might invoke the trigger.
Some of this was already in the code repository when the book, Pro MySQL was in it's final stages. Still, the wording in the chapter said things like "coming soon" or "this bug is reported and will likely be fixed by the time you read this."
I'm not sure I'm currently able of making a MySQL post withouth saying how whatever it is relates to the book. My apologies, that probably get's annoying.
Posted by mike at July 28, 2005 11:03 PM
Hard Drive Recovery Group offers hard disk data recovery services for RAID, laptops and servers. Complete clean room and hard drive repair service.Trackback Pings
TrackBack URL for this entry:
http://mike.kruckenberg.com/mt/mt-tb.cgi/284
Comments
Hi Mike
Indeed - it's also worth noting that restriction on calling procedures has been removed - as that now works in 5.0.10 as well! :)
There's a quick and dirty example over at my blog, but I'm sure you can whack up a quick test in no time ;)
Mark
Posted by: Mark Leith at August 4, 2005 1:47 PM