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 mobile phone number.

  • List Price: $44.99
  • Save: $11.24 (25%)
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
MySQL Stored Procedure Pr... has been added to your Cart
FREE Shipping on orders over $25.
Condition: Used: Good
Comment: Contains minimal markings and/or highlighting. Good readable copy with light amount of wear.
Trade in your item
Get a $1.50
Gift Card.
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

4.5 out of 5 stars 18 customer reviews

See all 5 formats and editions Hide other formats and editions
New from Used from
"Please retry"
"Please retry"
$10.31 $9.99
click to open popover

Frequently Bought Together

  • MySQL Stored Procedure Programming
  • +
  • High Performance MySQL: Optimization, Backups, and Replication
  • +
  • MySQL Cookbook: Solutions for Database Developers and Administrators
Total price: $117.99
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 (www.qnxo.com), the world's first active mentoring software.


The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See 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.5 out of 5 stars  See all reviews (18 customer reviews)
  • Amazon Best Sellers Rank: #701,624 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

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 49 people found this helpful. 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
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 9 people found this helpful. 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
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 8 people found this helpful. 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
Format: Kindle Edition Verified Purchase
I bought this to solve a problem. I read through about 70 percent of the book, at which point I felt ready to tackle the problem, and I did so successfully. Sure, you can Google how to do some of this stuff, but the book lays it out in an incremental fashion, in depth and in detail. Each example is broken down line by line in a chart. There's plenty of explanation, and it will cover topics and features you may not know existed if you're just hacking something together from Google. The book will turn you from a "I know some SQL" guy to a "I'm a DB professional."

If you're a developer, you may find that certain tasks are easier to code in the database. Batch oriented tasks, scheduled tasks, or processes triggered by a change in a value in the database are good candidates for a stored procedure solution.

The only downside from my experience is that I ordered the Kindle edition, and the screenshots are too small for the Kindle 2 to read comfortably. This book requires a DX-size Kindle.
Comment One person found this helpful. 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

MySQL Stored Procedure Programming
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: MySQL Stored Procedure Programming

What Other Items Do Customers Buy After Viewing This Item?