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.
Download to your computer
Kindle Cloud Reader

MySQL Cookbook 1st Edition

by Paul DuBois (Author)
4.4 out of 5 stars 38 customer reviews
ISBN-13: 978-0596001452
ISBN-10: 0596001452
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Facebook Twitter Pinterest <Embed>
Buy used
$5.81
Condition: Used - Very Good
In Stock. Sold by Orion LLC, Fulfilled by Amazon
Condition: Used: Very Good
Comment: .

Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and .

If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .

Access codes and supplements are not guaranteed with used items.
44 Used from $0.01
FREE Shipping on orders over $25.
More Buying Choices
17 New from $9.55 44 Used from $0.01
61 used & new from $0.01
See All Buying Options

There is a newer edition of this item:

MySQL Cookbook: Solutions for Database Developers and Administrators
MySQL Cookbook: Solutions for Database Developers and Administrators
$51.80
(19)
In Stock.
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Save up to 87% on Textbook Rentals Rent Textbooks
click to open popover

Editorial Reviews

Amazon.com Review

Read more

Review

Read more
See all Editorial Reviews
NO_CONTENT_IN_FEATURE
New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Paperback: 1022 pages
  • Publisher: O'Reilly Media; 1st edition (November 2002)
  • Language: English
  • ISBN-10: 0596001452
  • ISBN-13: 978-0596001452
  • Product Dimensions: 7 x 1.6 x 9.2 inches
  • Shipping Weight: 2.9 pounds
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (38 customer reviews)
  • Amazon Best Sellers Rank: #3,122,790 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

5.0 out of 5 starsThe only MySQL book needed for programming my web sites
By David L. Hickman on December 9, 2004
Format: Paperback
I built several web sites using PHP/MySQL and the only two books I use day-to-day are "MySQL Cookbook" and "PHP Cookbook".

If you're already somewhat familiar with MySQL, this book is a great reference for the SQL and database manipulation you already know how to do. In addition, the examples push the envelope of what is possible with MySQL making it a good learning tool for becoming truly expert.

Some of the information in the book I found useful includes:

- simplifying complex SQL using temporary tables.

- using FULLTEXT searches (similar to pattern matching but more efficient and easier to code when you're looking for the same text in several columns at the same time).

- effective use of LEFT JOIN's for finding rows in one table that don't have a match in another table.

- effective use of LAST_INSERT_ID( fieldName + 1 ) for transactionally updating a numeric field without using transactions and without locking a table.

- numbering output rows using SQL variables (select @rownum := @rownum + 1; (see chapter 13.9))

I really can't say enough good things about this book. It's comprehensive, easy to read and just plain awesome.
Comment 37 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
4.0 out of 5 starsA Hand-on guide to MySQL
By A Customer on May 20, 2003
Format: Paperback
There are many databases out there. MySQL is one of the better ones. It's a free (for personal use) database system which can be easily integrated into a web application on virtually any system. It has supports most of the standard feature found in most database system and has quiet a few features unique to MySQL. This particular book is a good reference for the experienced user as well as for new comers and as an added bonus even covers MySQL 4.0.
This is book was my first introduction to O'Reilly's cookbook series. It provides solutions to some of the most common challenged faced by the particular subject being covered (in this case MySQL). I thoroughly enjoyed it and was quiet impressed with it. Too many technical books simply introduce the concept without relating it to real world applications.
This particular book introduces all of the most basic concepts of database manipulation (table creation, data insertion, data deletion, data update). As well as writing simple and advanced SQL statements to retrieve data. It approaches database design using 4 of the most popular languages (Perl, PHP, Python and Java). These are only a few of the many possible languages which can be used to manipulate a MySQL database.
MySQL cookbook touches on a variety of different topics which I don't have the space or time to cover in detail, but here is a list of them:
* Handeling duplicates
* MySQL on the Web
* Processing Web input with MySQL
* Using MySQL-based Web Session Management
One of my favorite topics covered in the book is the idea of storing binary data such as images within a database. Although not ideal for most cases (unless you need fast access to a vast array of images), just the idea of it has a certain kewlness effect.
Well, overall I give it 4 out of 5 stars. It needs to touch slightly more on the basic concepts of databases, and it can become the only book you'll ever need for MySQL.
Comment 17 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
5.0 out of 5 starsa nice addition to O'Reilly's Cookbook series
By A Customer on April 13, 2003
Format: Paperback
As an experienced Oracle DBA I had a need to learn about MySQL for the development of the FmPro Migrator utility to migrate FileMaker databases to MySQL. This book enabled me to quickly learn how to perform tasks in MySQL which are equivalent to what I would perform with Oracle. Congratulations to O'Reilly and Paul DuBois for continuing the fine tradition of Cookbook series books.
Comment 13 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
5.0 out of 5 starsExcellent All-Around Guide To MySQL Programming
By Alex Green on April 5, 2004
Format: Paperback
I am an experienced web developer and recently started using Perl with MySQL to build database-driven CGI applications.
MySQL Cookbook by Paul DuBois turned out to be a valuable reference resource.
While the title mentions only MySQL, the book provides a great deal of solutions (and code) for using MySQL with Perl, PHP, Python and Java. If you are familiar with any of these computer languages, this book and MySQL manual is all you need to start building applications with MySQL-compatible database backend.
Comment 23 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
5.0 out of 5 starsIncredibly Useful
By C. E. Morgan on November 11, 2002
Format: Paperback
This book is well done, clearly written and sensibly organized. I read the same author's New Riders Book on MySQL and found it similarly useful; but if you've already got all the theory down, this may well be the only MySQL book you'll need. Wish I'd had it a few years ago.
Comment 13 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
5.0 out of 5 starsGreat MySQL Recipes also useful to users of other brands of SQL
By calvinnme HALL OF FAME on January 2, 2007
Format: Paperback
This book should be useful for anybody who uses MySQL, ranging from individuals who want to use a database for personal projects such as a blog or Wiki, to professional database and web developers. The book should also appeal to people who do not now use MySQL, but would like to. For example, it should be useful if you want to learn about databases but realize that a "big" database system such as Oracle isn't the best choice as a learning tool. The following paragraphs summarize each chapter to give you an overview of the book's contents.

Chapter 1, Using the mysql Client Program, describes how to use the standard MySQL command-line client. In addition, the chapter discusses other ways to use mysql, such as how to number output lines or make long lines more readable, how to generate various output formats, and how to log mysql sessions.

Chapter 2, Writing MySQL-Based Programs, demonstrates the basic elements of MySQL programming: how to connect to the server, issue queries, retrieve the results, and handle errors. It also discusses how to handle special characters and NULL values in queries, how to write library files to encapsulate code for commonly used operations, and describes various ways to gather the parameters needed for making connections to the server.

Chapter 3, Selecting Data from Tables, covers several aspects of the SELECT statement, which is the primary vehicle for retrieving data from the MySQL server: specifying which columns and rows you want to retrieve, performing comparisons, dealing with NULL values, and selecting one section of a query result.

Chapter 4, Table Management, covers table cloning, copying results into other tables, using temporary tables, and checking or changing a table's storage engine.Read more ›
Comment 11 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

Most Recent Customer Reviews

5.0 out of 5 starsGreat Publisher

Just bought it for reference. Never really used it. But its a good publisher.

Published 26 days ago by Nickchia
5.0 out of 5 starsFive Stars

another great find

Published 5 months ago by Jesse Hess
4.0 out of 5 starsThe book I was looking for

Everything I expected

Published 16 months ago by Jamie Smith
4.0 out of 5 starsuseful

Good book

Published 18 months ago by Sailorboy34
5.0 out of 5 starsConcise and Full of Examples

I chose the book after reading the table of contents and other reviews. I had tinkered with SQL enough to make me dangerous. Read more

Published on October 6, 2014 by Preston M.
5.0 out of 5 starsPortable class room reference

Already had the paper copy but needed a reference in the class room for students as they work through their projects. Read more

Published on June 14, 2014 by Jeff O'Byrne
1.0 out of 5 starsWhy the high ratings?

I bought this book a couple of years ago on the strength of its Amazon ratings. Over this time, I haven't been able to use it even once. Read more

Published on March 29, 2014 by Groundhog Day
5.0 out of 5 starsDifferent and awesome

This book takes a different approach than most mysql books. It is definitely more about tweaking than learning but is awesome for what it is.

Published on March 5, 2014 by Jeffrey Smith
5.0 out of 5 starsVery useful tool!

This book provides very useful ideas and examples for any developer. It is definitely worth having in your programming library.

Published on January 14, 2014 by FLM
4.0 out of 5 starsAsk Felgall - Book Review

This book is huge and like the other books in the cookbook series the primary purpose of the book is to provide real solutions to real life problems. Read more

Published on November 23, 2011 by Stephen Chapman

There's a problem loading this menu right now.

Learn more about Amazon Prime.