Guide to MySQL 5 Stored ProceduresBy Blane Warrene
MySQL AB has published the first in a series of ebooks featuring coverage of the new functionality in version 5 of their popular database. A link to the PDF document is on the page and does not require registration.
Peter Gulutzan, one of MySQL’s software architects, has authored the intitial release. The publication stretches some 67 pages and covers stored procedures. Future pieces appear to be in the works covering Triggers and Views.
The approach is great – starting simple for those who did not come from other systems with this capability – and then wrapping up with real world examples that leverage one or more of the new features in a scenario that may have previously been seen as “undoable” or extremely difficult.
I also like the side-by-side comparison to Oracle, Microsoft SQL Server and IBM DB2.