The implementation of stored procedures in MySQL 5.0 a huge

milestone -- one that is expected to lead to widespread enterprise adoption of

the already extremely popular MySQL database. If you are serious about

building the web-based database applications of the future, you need to

get up to speed quickly on how stored procedures work -- and how to

build them the right way. This book, destined to be the bible of stored

procedure development, is a resource that no real MySQL programmer can

afford to do without.

In the decade since MySQL burst on the scene, it has become the

dominant open source database, with capabilities and performance

rivaling those of commercial RDBMS offerings like Oracle and SQL

Server. Along with Linux and PHP, MySQL is at the heart of millions of

applications. And now, with support for stored procedures, functions,

and triggers in MySQL 5.0, MySQL offers the programming power needed

for true enterprise use.

MySQL’s new procedural language has a straightforward syntax, making it

easy to write simple programs. But it’s not so easy to write secure,

easily maintained, high-performance, and bug-free programs. Few in the

MySQL world have substantial experience yet with stored procedures, but

Guy Harrison and Steven Feuerstein have decades of combined expertise.

In "MySQL Stored Procedure Programming," they put

that hard-won experience to good use. Packed with code examples and covering

everything from language basics to application building to advanced

tuning and best practices, this highly readable book is the one-stop

guide to MySQL development. It consists of four majorsections:

MySQL stored programming fundamentals -- tutorial, basic

statements, SQL in stored programs, and error handling

Building MySQL stored programs -- transaction handling,

built-in functions, stored functions, and triggers

MySQL stored programs in applications -- using stored

programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET)

Optimizing MySQL stored programs -- security, basic and

advanced SQL tuning, optimizing stored program code, and programming

best practices

A companion web site contains many thousands of lines of code, that you

can put to use immediately.

Guy Harrison is Chief Architect of Database Solutions at Quest Software

and a frequent speaker and writer on MySQL topics. Steven Feuerstein is

the author of "Oracle PL/SQL Programming," the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

The implementation of stored procedures in MySQL 5.0 a huge milestone -- one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work -- and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.

MySQL’s new procedural language has a straightforward syntax, making it easy to write simple programs. But it’s not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.

In MySQL Stored Procedure Programming, they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections:

* MySQL stored programming fundamentals -- tutorial, basic statements, SQL in stored programs, and error handling
* Building MySQL stored programs -- transaction handling, built-in functions, stored functions, and triggers
* MySQL stored programs in applications -- using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET)
* Optimizing MySQL stored programs -- security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices

A companion web site contains many thousands of lines of code, that you can put to use immediately.

Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics. Steven Feuerstein is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

The implementation of stored procedures in MySQL 5.0 a huge milestone - one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work - and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without. In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use. MySQL’s new procedural language has a straightforward syntax, making it easy to write simple programs. But it’s not so easy to write secure, easily maintained, high-performance, and bug-free programs.

Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise. In "MySQL Stored Procedure Programming", they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections: MySQL stored programming fundamentals - tutorial, basic statements, SQL in stored programs, and error handling; Building MySQL stored programs - transaction handling, built-in functions, stored functions, and triggers; MySQL stored programs in applications - using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET); and, Optimizing MySQL stored programs - security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices. A companion web site contains many thousands of lines of code, that you can put to use immediately. Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics.

Steven Feuerstein is the author of "Oracle PL/SQL Programming", the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

MySQL Stored Procedure Programming covers a lot of ground. The book starts with a thorough introduction to stored procedures programming and functions, covering the fundamentals of data types, operators, and using SQL in stored procedures. You’ll learn how to build and maintain stored programs -- covering transactions, stored functions, and triggers -- and how to call and use MySQL-based stored procedures in a variety of languages, including PHP, Perl, Python, .NET, and Java. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

Guy Harrison has worked with databases for more than a decade, has conducted many MySQL and Oracle training seminars, and is author of several books on Oracle, including "Oracle Desk Reference" (Prentice Hall PTR). Currently a product architect at Quest Software, Harrison has conducted many training seminars and has authored several articles for the Oracle Technical Journal. He resides in Australia.

Steven Feuerstein is considered one of the world’s leading experts on the Oracle PL/SQL language. He is the author or coauthor of "Oracle PL/SQL Programming", "Oracle PL/SQL Best Practices", "Oracle PL/SQL Programming: Guide to Oracle8i Features", "Oracle PL/SQL Developer’s Workbook", "Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages", and several pocket reference books (all from O’Reilly). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992. He is currently designing and building Qnxo (www.qnxo.com), the world’s first active mentoring software.

The implementation of stored procedures in MySQL 5.0 a huge milestone -- one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work -- and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.

In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.

MySQL’s new procedural language has a straightforward syntax, making it easy to write simple programs. But it’s not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.

In MySQL Stored Procedure Programming, they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections:

• MySQL stored programming fundamentals -- tutorial, basic statements, SQL in stored programs, and error handling
• Building MySQL stored programs -- transaction handling, built-in functions, stored functions, and triggers
• MySQL stored programs in applications -- using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET)
• Optimizing MySQL stored programs -- security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices

A companion web site contains many thousands of lines of code, that you can put to use immediately.

Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics. Steven Feuerstein is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.

Much more than expected
This book clearly covers stored procedure programming well. Of course, it goes over basic syntax and provides examples, but it also goes much farther than that. This book discusses optimization of MySQL queries regardless of the use - in or out of sprocs. It also did a very nice job of discussing the use of cursors - the ability to iterate through the results of a query without being pelted with the entire result set all at once.

If you’re developing on MySQL 5 or greater, and you’re serious about letting the database handle things that make sense (i.e. denormalization, administration, and putting business logic into the database), this is an excellent resource.

Hit(s):

o Thorough coverage of
- o stored procedures
- o functions
- o triggers
- o cursors
o Explains stored procedure optimization very well
o Serves as stored procedure cookbook
o Excellent coverage of stored procedure best practices
o Demonstrates use of stored procedures with languages like PHP, Perl, Java, and others.

Miss(es):

o Title doesn’t do it justice.

the first and only Mysql stored procedure book
This is the first and only book about Mysql stored procedured and since it was written by the query tuning guru Guy Harrison, it also includes nice tips on query tuning. Highly recommended, just be forewarn that this is for advance Mysql developers or DBA only. Also, be aware that Mysql stored procedure as of release 5.0 and 5.1 won’t buy you much performance since Mysql parse stored procedures scripts every time it run unlike other RDBMS like Oracle and MSSQL. If you want better performance, you should make use of prepared statements inside a stored procedure.

MySQL Stored Procedures, In Depth
I have been working with MySQL for several years as a database back-end for Java, Ruby and C# programming projects. After upgrading to version 5, I have been meaning to look into MySQL’s support for stored procedures.

The MySQL Stored Procedure Programming book was my first read on the subject and I found it quite useful. It covers not only stored procedures, but also functions and triggers, collectively called ’stored programs’ in the book. While there are many books on MySQL, this book is dedicated to the stored programs domain and provides a lengthy treatment of the subject.

During the introduction, the authors provide a veritable laundry list of MySQL resources including many books and websites. The basic tools for creating stored programs in MySQL are visited and help set the groundwork for a ’read, type in the example and run it’ feedback loop. Throughout the book, the examples are clear and easy to follow.

The introduction is followed by a brief tutorial, highlighting stored procedures, functions and triggers. What follows is two sections of chapters, over 200 pages in length, diving into the details of the stored procedure language fundamentals, blocks, conditional statements, iterative programming, error handling, the creation and maintenance of stored programs, transaction management, MySQL built-in functions, stored functions and triggers.

The next section of the book is of particular value to software developers that use MySQL in their applications. Over 150 pages showing you how to use MySQL stored programs from PHP, Java, Perl, Python and .NET. The Java section even shows the basics of using stored procedures with Hibernate and Spring.

After that, you’ll be greeted with a 110 page medley of options to help you optimize your MySQL stored programs. The subject of tuning your SQL is addressed over the course of three chapters, from basic through advanced tuning topics. Additional optimization techniques such as reducing network traffic with stored programs, optimizing loops, recursion, cursors, trigger overhead and more are found in the final chapter of this section.

The book closes out with a chapter on best practices in MySQL stored program development. MySQL Stored Procedure Programming has earned a space on the MySQL shelf of my technical library. It’s a fine book that will help you take your MySQL programming experience to another level.

MySQL Stored Procedure Programming
The good: I found to book to be generally useful. The approach the book takes is good. Lots of examples are provided along with a good amount of explanation.


The not-so-good: There seem to be quality or editorial issues with some of the examples. When I run them through the query browser in MySQL version 5 I have problems with some of them. For example Example 2-7 calls another procedure new_salary, which doesn’t seem to exist by that name in the book or on the website. This makes it much more time consuming for a newbie to actually run and digest the examples than it should.

Essential material when learning spp on MySQL
Being fairly new to MySQL (but not to programming) I needed to develop an application using PHP/OOP with MySQL and stored procedures. This book is pretty concise and got me going quickly. At the time, I searched the Amazon book offerings and also books on the shelf at Barnes & Noble. This book is the only one providing clear and concise material on the subject.

I do wish the coverage would have been more detailed using PHP data objects (PDO) in combination with stored procedures that use various combinations of INPUT, OUTPUT and INPUT-OUTPUT parameters in addition to exception processing, etc. That would have been great but then, this isn’t a PHP book. Too bad most PHP books seem to focus more on the basics of the language and don’t delve into the weighty matters of real-world commercial application development.

Good coverage of Stored routines, and more!
This book has an excellent coverage of the MySQL 5.0 stored routines (stored procedures, stored functions and triggers).
But it also provides with invaluable hints and guidelines for general MySQL practices.

The book starts with PART I: covering the syntax and rules for stored routines. This part is straightforward and a very fast read. The authors tend to repeat themselves on occasion, though only when relevant.

PART II looks more closely at the particular rules for stored funtions and triggers. It also offers a transaction managing chapter, which describes transactions in MySQL in general, and in stored programming in particular. This chapter is very informative.

PART III discusses the use of stored routings from external programs: PHP, Java, Perl, Python, .NET. The authors establish their view of correct usage and provide with general recommendations.

In general, these three parts cover the stored routines material.
However, here comes a nice surprise: enter Part IV, which is a real gem.
This last part of the book discusses in depth MySQL query optimizations, indexing methods, performance issues, most unrelated with stored programming.
Why? The authors explain (and I agree with them), that most stored routines code will usually have SQL queries DML statements in them. It is their opinion, then, that to write good, efficient, stored procedures, one must be aware of how MySQL optimizes and handles complex queries.
I am not new to MySQL, yet have learned quite a few new things from this last part.
The book ends with a "best practices" chapter, which mostly provides summary for all issues discussed in the book, including some general recommendations for best practices in programming (which could have been left out, in my opinion).

All in all, this book is certainly a very good reference for anyone wishing to write stored functions/procedures/triggers in MySQL. The authors certainly have a strong expertise on the subject, and have a lot to tell.

Highly recommended!
It walks you through writing, maintaining, and debugging stored procedures. It can be used as a reference and tutorial.
I found Part IV Optimizing Stored Programs particularly useful.

Might not be for you
I’ve found that just about any book on Stored Procedures will work fine for MySQL 5 programmers... so don’t feel tied to books with MySQL in the name to learn about the topic. I’ve seen other books and websites which were easier for me to understand. Not sure if it was a reading/writing style conflict or what... but I ended up not keeping this one.

VERY VERY HIGHLY RECOMMENDED!!
Are you a MySQL programmer? If you are, then this book is for you. Authors Guy Harrison and Steven Feuerstein, have done an outstanding job of writing a book that will help MySQL practitioners realize the full potential of MySQL stored programs.

Harrison and Feuerstein, begin by introducing the MySQL stored program language and provide a detailed description of the language structure and usage. Then, the authors describe how you can use the MySQL elements to build functional and useful store programs. The authors then show you how to use the stored programs within applications.
Finally, they show you how to get programs to work correctly by making them perform efficiently, robust and secure, and be easily maintained.

This most excellent book describes the stored program language introduced in MySQL 5.0. More importantly, this book will help you get the job done!!

Absolute Necessity For MySQL Developers
’MySQL Stored Procedure Programming’ by Guy Harrison is a wonderful book for any MySQL developers out there in the world. With the release my MySQL 5.0, stored procedures/functions and triggers were finally added, making MySQL a real-world database that could successfully compete with SQL Server and Oracle. While nowhere near as bloated as those 2 behemoths, MySQL has a rich, loyal following that loves this ’little database that could’, but until the latest version, what it could do was good, but not good enough for many people.

Having MySQL 5 and the ability to now write stored procedures, this DB could be used to power even the most important of web applications. Having this book in your hands now gives you the power to learn how to perform this very task efficiently and effectively.

I love the writing, size, and great layout of this text. In true O’Reilly fashion it’s packaged for the masses and it is a pleasure to learn from.

Chapter Overview:

01. Into to MySQL Stored Programs
02. MySQL Stored Programming 101
03. Language Fundamentals
04. Blocks, Conditional Statements, Iterative Programming
05. Using SQL in Stored Programming
06. Error Handling
07. Creating and Maintaining Stored Programs
08. Transactions
09. MySQL built-in functions
10. Stored Functions
11. Triggers
12. Using Stored Programs in applications
13. MySQL with PHP
14. MySQL with Java
15. MySQL with Perl
16. MySQL with Python
17. MySQL with .NET
18. Stored Program Security
19. Tuning Stored Programs
20. Basic SQL Tuning
21. Advanced SQL Tuning
22. Optimizing Stored Program Code
23. Best Practices in MySQL Stored Program Development

Everything about this book just screams YES YES YES!!! One of my favorites that I have had the pleasure to review and unless you are the most awesome of SQL developers, I have no doubts that you will love this book too!!

***** HIGHLY HIGHLY RECOMMENDED

Excellent and authoritative
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.

an excellent book
Having worked in java and oracle with pl/sql some time ago, I’m in the "probably better not to use stored procedures" camp for most environments - but now that mysql offers them, I figured it was best to see how they tackled the problem and this o’reilly book looked good by authors with good credentials. And, fortunately, O’Reilly didn’t let me down - they’ve had really strong offerings recently after a bit of a bad spell and this book was no exception.

This book is well written and well organized - something too few books are these days! It focuses on incremental teaching, but sidesteps the pitfalls that many such books do by pointing out when certatin features are glossed over at this point to be further explained in a future chapter. This is the perfect way to handle that problem, but one so few books take the time to do, leaving you puzzling over whether or not you need to fully understand particular examples.

It’s divided into 4 sections. For me, the heart of the book was in the first 2. The first "Stored Programming Fundamentals" gives you the nuts and bolts of the language - loops, blocks, variables, error handling, etc.. Very well written, very well organized and easy to follow.

The second part "Stored Program Construction" goes into more detail with working examples of stored procedures and functions. More language details are brought to light, it demonstrates how to use transactions in this context and triggers are introduced and explained. These two sections were great, to the point and easy to follow. The only minor qualm I had was their only incidental discussion of scoping - they’d address it with a sentence here and a note there, leaving you to glean how things worked. It’s not complex, but a short paragraph dedicated to scope would have really been nice.

The third part, I think, was unnecessarily long. "Using MySQL Stored Programs in Applications" - this covered how to work in php, java, perl, python and .net. Which was great, but they put in about 150 pages, almost a quarter of the book to this task and almost all of it was dedicated to the basics of how to use databases in these languages. Very basic querying, etc. It wasn’t in the scope of the book and shouldn’t have been - the whole thing should have been a single chapter that just discussed how to work with stored programs in each of the languages.

The last section, "optimizing stored programs" was very good. It suffered a little bit from covering topics that shouldn’t have been in the book - but they cover it very well. SQL Tuning is given a lot of pages, but they very succinctly cover many bases in a very easy to grasp manner. They discuss how to use stored programs to increase security, and they dedicate a chapter to the actual mechanics of optimizing your stored program code (aside from optimizing the sql that it might include). They conclude on an excellent Best Practices chapter that gives you the authors’ insights on everything from development to style to sql practices. I really enjoy it when books include these, as it gives a lot of insight into how the authors think about programming and you can see where your thoughts coincided with and contradict - and hopefully (as was the case with this book) get you thinking a little bit more about things you might not be actively thinking about.

Overall this book is a great book. It’s biggest failing, if you can call it that, was including too much. I would have liked a book maybe 2/3 the size and more tightly focussed. There are many books on sql optimization and hordes of books and online resources dedicated to using mysql with various programming languages. An excellent book that gives a pretty balanced view of the pros and cons of stored programming (although they do show a slight bias towards the use of - but what can you expect? :).

Excellent and authoritative
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.