Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Tell the Publisher!
Id 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)

Available from these sellers.


Amazon Price New from Used from
Tankobon Hardcover --  
Paperback 23.14  
Paperback, 7 Nov 2002 --  
There is a newer edition of this item:
MySQL Cookbook: Solutions for Database Developers and Administrators MySQL Cookbook: Solutions for Database Developers and Administrators
Usually dispatched within 10 to 13 days

Book Description

7 Nov 2002 0596001452 978-0596001452 1

While MySQL has turned up among high profile users such as Yahoo!, NASA and the U.S. Census Bureau, the rising popularity of this open source database is especially keen among users with little database experience. These days, even a small organization or web site has uses for a database, and MySQL is an obvious choice. Affordable and easy to use, MySQL packs the power, speed and efficiency that enable it to rival expensive, proprietary database solutions. Yet, even if you know the basics, anyone without practical MySQL experience--novices and skilled DBAs alike--might stumble over common database-related tasks. Fortunately, there's a sensible shortcut.MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. But MySQL Cookbook is more than a collection of cut-and-paste code. You also get explanations of how and why the code works, so you can learn to adapt the techniques to similar situations.The book covers a lot of ground. Solutions for typical MySQL dilemmas range from simple ways to find all records that contain a given string, to more difficult problems, such as finding matching/non-matching records in two tables. Whether you use MySQL on Unix, Linux, Windows or the Mac OS X platform, the book will show you how to:

  • Import data from external sources
  • Export data for use by external programs
  • Access MySQL from your web server
  • Use scripts with MySQL to read queries from a file
  • Access MySQL from within client programs that use Perl, PHP, Java, Python and other languages
  • Construct queries that solve commonly-occurring questions
  • Interact with the server
This learn-as-you-go resource will help users of all levels exploit MySQL more fully. MySQL Cookbook supplies you with an armory of ready-made techniques for specific problems so that, even if you're an experienced MySQL user, you don't have to write everything from scratch.

Product details

  • Paperback: 1024 pages
  • Publisher: O'Reilly Media; 1 edition (7 Nov 2002)
  • Language: French
  • ISBN-10: 0596001452
  • ISBN-13: 978-0596001452
  • Product Dimensions: 23.4 x 17.8 x 4.2 cm
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: 1,297,721 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

Book Description

Solutions & Examples for Database Developers and DBAs --This text refers to an alternate Paperback edition.

Inside This Book (Learn More)
Browse and search another edition of this book.
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