Industrial Deals Books Holiday Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Adele egg_2015 Fire TV Stick Subscribe & Save Gifts Under $50 Amazon Gift Card Offer minions minions minions  Amazon Echo Starting at $84.99 Kindle Black Friday Deals Shop Now Tikes
MySQL Stored Procedure Programming and over one million other books are available for Amazon Kindle. Learn more

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

  • List Price: $44.99
  • Save: $12.37 (27%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Gift-wrap available.
MySQL Stored Procedure Pr... has been added to your Cart
Condition: Used: Acceptable
Comment: FREE TRACKING ON ALL ORDERS! Support Your Planet. Buy CLEAN EARTH BOOKS. Shipping orders swiftly since 2008. A used book that may have some cosmetic wear (i.e. shelf-wear, slightly torn or missing dust jacket, dented corner...) All text in great shape! Comes with our 100% Money Back Guarantee. Our customer service can't be beat! Tracking included on all orders.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

MySQL Stored Procedure Programming Paperback – April 4, 2006

17 customer reviews

See all 3 formats and editions Hide other formats and editions
New from Used from
"Please retry"
"Please retry"
$21.09 $1.59

Best Books of the Year So Far
Looking for something great to read? Browse our editors' picks for 2015's Best Books of the Year in fiction, nonfiction, mysteries, children's books, and much more.
$32.62 FREE Shipping on orders over $35. In Stock. Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • MySQL Stored Procedure Programming
  • +
  • Learning MySQL
  • +
  • High Performance MySQL: Optimization, Backups, and Replication
Total price: $92.54
Buy the selected items together

Editorial Reviews

Book Description

Building High-Performance Web Applications in MySQL

About the Author

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 (, the world's first active mentoring software.


Hero Quick Promo
Holiday Deals in Kindle Books
Save up to 85% on more than 1,000 Kindle Books. These deals are valid until November 30, 2015. Learn more

Product Details

  • Paperback: 640 pages
  • Publisher: O'Reilly Media; 1 edition (April 7, 2006)
  • Language: English
  • ISBN-10: 0596100892
  • ISBN-13: 978-0596100896
  • Product Dimensions: 7 x 1.3 x 9.2 inches
  • Shipping Weight: 2.1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Best Sellers Rank: #773,652 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

48 of 49 people found the following review helpful By Felix Sheng on June 9, 2006
Format: Paperback
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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
8 of 8 people found the following review helpful By Shlomo Noach on November 21, 2007
Format: Paperback
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.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
8 of 8 people found the following review helpful By Rick H on February 3, 2008
Format: Paperback
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.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
9 of 12 people found the following review helpful By Dan McKinnon VINE VOICE on August 14, 2006
Format: Paperback
'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

Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
MySQL Stored Procedure Programming
This item: MySQL Stored Procedure Programming
Price: $32.62
Ships from and sold by

What Other Items Do Customers Buy After Viewing This Item?