Buy New

Sign in to turn on 1-Click ordering.
Buy Used
Used - Good See details
Price: £21.51

Trade in Yours
For a £2.75 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL Cookbook [Paperback]

Paul DuBois
4.8 out of 5 stars  See all reviews (5 customer reviews)
Price: £32.50 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.


Amazon Price New from Used from
Tankobon Hardcover --  
Paperback £32.50  
Trade In this Item for up to £2.75
Trade in MySQL Cookbook for an Amazon Gift Card of up to £2.75, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
There is a newer edition of this item:
MySQL Cookbook: Solutions for Database Developers and Administrators MySQL Cookbook: Solutions for Database Developers and Administrators
In stock.

Book Description

7 Dec 2006 059652708X 978-0596527082 2

Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.

The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.

Other recipes in the book teach you to:

  • Access data from multiple tables at the same time
  • Use SQL to select, sort, and summarize rows
  • Find matches or mismatches between rows in two tables
  • Determine intervals between dates or times, including age calculations
  • Store images into MySQL and retrieve them for display in web pages
  • Get LOAD DATA to read your data files properly or find which values in the file are invalid
  • Use strict mode to prevent entry of bad data into your database
  • Copy a table or a database to another server
  • Generate sequence numbers to use as unique row identifiers
  • Create database events that execute according to a schedule
  • And a lot more

MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.

Frequently Bought Together

MySQL Cookbook + High Performance MySQL: Optimization, Backups, and Replication + MySQL Stored Procedure Programming
Price For All Three: £96.99

Buy the selected items together

Product details

  • Paperback: 980 pages
  • Publisher: O'Reilly Media; 2 edition (7 Dec 2006)
  • Language: English
  • ISBN-10: 059652708X
  • ISBN-13: 978-0596527082
  • Product Dimensions: 23.4 x 17.8 x 5.3 cm
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: 474,284 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description


MySQL Cookbook' is a great book for anyone developing a user interface to a MySQL database. -- Brad Crockett, Big Blue and Cousins, Feb 2003 --This text refers to an out of print or unavailable edition of this title.

Book Description

Solutions & Examples for Database Developers and DBAs

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

3 star
2 star
1 star
4.8 out of 5 stars
4.8 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars Great Book 9 Dec 2010
Format:Paperback|Verified Purchase
It is not for the complete beginner, but you don't have to be too far off to get some real benefit from using this book.

The discussions about why you would use a particular technique are excellent too.

In my opinion it is great. I bought it and I am still using it.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Very Useful 10 Oct 2013
Format:Paperback|Verified Purchase
This book was a great starter when I got into MySQL and has been the foundation for all my projects and knowledge of MySQL. A great and useful book.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars Good book, recommanded 18 Oct 2010
I like the style of the book which tackles the problems encountered rather than introducing theories chapter by chapter.

The reason I gave it a 4 is that it didn't cover some more advanced skills for database admin such as database management and securities.
Comment | 
Was this review helpful to you?
4 of 6 people found the following review helpful
5.0 out of 5 stars Does Exactly What It Says On The Tin 14 May 2008
A few pages past the table of contents, I had solved two issues that had been bugging me since my last install. It was pretty minor stuff, but could I as heck find the answers online. It just shows what research, presentation, and quality control can achieve. So, another score for books over bytes.

The layout is uncluttered, and you can usually get the gist without reading through pages of preamble and exposition. The examples are practical and adaptable (no long and complex routines found on some sites) so they can almost be cut and pasted into your own applications. As your applications develop, there's always something else you can add.

The only downside is that it's a book - a few mods to MySQL and you might have to fork out for the next revision. Still, I should have got my money's worth by then.
Was this review helpful to you?
6 of 9 people found the following review helpful
5.0 out of 5 stars Teaches you SQL 31 Mar 2006
Explains by example so many common queries you'll be able to solve a wide variety of problems instantly. SQL is a deceptively deep language and getting to grips with this small army of queries gives you the basics to build on.
Easy reading and sensible examples. Some omissions (insert) but it's not the complex stuff - that part is really taught well.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category