Reviews for MySQL Stored Procedure Programming

1. A good buy!

   Rated 4 out of 5 stars, March 12th, 2010

   I bought this recently to get into developing and expanding my use of MySQL to use triggers and stored procedures.
   
   Previously been using V4 heavily and whilst I had some prior experience of triggers and stored procedures on SQL Server and Oracle it was not extensive. This book whilst appears a little long winded in places actually provides a very logical approach to developing stored procedures, improving your skills and even tuning/best practice to get the most performance out of your database.
   
   This is a book for those with some prior experience of SQL and perhaps touched on triggers/stored procedures who want to expand.

2. Excellent and authoritative

   Rated 4 out of 5 stars, May 12th, 2006

   I was somewhat reluctant to review this mighty tome when I saw that it weighed in at 636 pages, but I'm very glad I did. My initial impressions were unfavourable: there were some annoying typos even before I'd reached Page 1. Nevertheless, the book quickly gets into its stride and covers a huge amount of information before packing the reader off to tame the wilds of stored procedure programming.
   
   The book is structured in four parts: Stored programming Fundamentals, Stored Program Construction, Using MySQL Stored Programs in Applications and Optimising Stored Programs.
   
   The 150-page introductory section gives a brief tutorial on the subject: it's comprehensive enough that you can be productive from just this section.
   
   Part II is much more of a reference manual, covering stored procedures, stored functions, triggers, views and transactions. I fully expect to make most use of this when I develop stored programs.
   
   Part III covers the interaction between stored programs and a few popular programming environments (Perl, PHP, Python, Java and .NET). Other than handling stored procedures' facility for returning multiple tables, these chapters could easily have been found in a general book on MySQL.
   
   Part IV shows how to make stored programs fast. It is an excellent primer for SQL optimisation in MySQL as well as the other aspects of performance that impinge on stored programs.
   
   I wouldn't hesitate to recommend this book to anyone who uses MySQL, either as a knowledgable amateur or professionally.