« 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