Programming Books C Java PHP Python Learn more Browse Programming Books
MySQL Stored Procedure Programming and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $44.99
  • Save: $13.21 (29%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Want it tomorrow, April 18? Order within and choose One-Day Shipping at checkout. Details
FREE Shipping on orders over $35.
Condition: Used: Good
Add to Cart
Trade in your item
Get a $2.00
Gift Card.
Have one to sell?
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


See all 4 formats and editions Hide other formats and editions
Amazon Price New from Used from Collectible from
Kindle
"Please retry"
Paperback
"Please retry"
$31.78
$24.62 $12.01

Frequently Bought Together

MySQL Stored Procedure Programming + Learning MySQL + High Performance MySQL: Optimization, Backups, and Replication
Price for all three: $91.28

Buy the selected items together

Customers Who Bought This Item Also Bought

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

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

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.


More About the Authors

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

Customer Reviews

4.6 out of 5 stars
5 star
11
4 star
2
3 star
2
2 star
0
1 star
0
See all 15 customer reviews
Very well written, very well organized and easy to follow.
Felix Sheng
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!!
Dan McKinnon
This book has an excellent coverage of the MySQL 5.0 stored routines (stored procedures, stored functions and triggers).
Shlomo Noach

Most Helpful Customer Reviews

46 of 47 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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
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

22.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Product Images from Customers

Most Recent Customer Reviews

Search
ARRAY(0xa2f113c0)

What Other Items Do Customers Buy After Viewing This Item?