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
Sell yours for a Gift Card
We'll buy it for $2.00
Learn More
Trade in now
Have one to sell? Sell on Amazon

Learning MySQL Paperback – November 21, 2006

ISBN-13: 978-0596008642 ISBN-10: 0596008643
Buy used
Buy new
Used & new from other sellers Delivery options vary per offer
79 used & new from $8.07
Rent from Amazon Price New from Used from
"Please retry"
Paperback, November 21, 2006
"Please retry"
$20.82 $8.07
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now
$29.48 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Learning MySQL + High Performance MySQL: Optimization, Backups, and Replication
Price for both: $62.41

Buy the selected items together

Editorial Reviews


"I recommend Tahaghoghi and Williams' Learning MySQL as an introduction to database solutions, especially as applied to web development. Buy this book and you won't be disappointed." - James Pyles, Linux Magazine, March 2007

Book Description

Get a Handle on Your Data

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: 618 pages
  • Publisher: O'Reilly Media (November 24, 2006)
  • Language: English
  • ISBN-10: 0596008643
  • ISBN-13: 978-0596008642
  • Product Dimensions: 7 x 1.4 x 9.2 inches
  • Shipping Weight: 1.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (27 customer reviews)
  • Amazon Best Sellers Rank: #270,673 in Books (See Top 100 in Books)

More About the Authors

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

Customer Reviews

4.1 out of 5 stars

Most Helpful Customer Reviews

37 of 42 people found the following review helpful By Dan McKinnon VINE VOICE on April 18, 2007
Format: Paperback
The 'Learning' series of books by O'Reilly is one of my favorites by far. The thing the separates 'Learning' books from other ones is the fact that these books (for the most part) assume that the reader has a very limited knowledge of said subject matter and ramps them up in logical succession until the point where they are comfortable and developing/designing like a seasoned pro. A 'Learning' book won't make you into an uber pro overnight, but if you are the type that better learns away from the classroom and would rather spend said time (and a lot less money) sitting in front of a computer at home with a book on your lap, you could do a lot less than this O'Reilly line of books.

With 'Learning MySQL' the tradition most definitely continues. ~600 pages await the reader who picks up this gem and you don't need to have any extensive database experience in order to be able to pick this up and start cracking! From the basics of installation on Linux, Windows and the Mac to basic SQL like writing queries and stored procedures, the foundation is all there. Continuing on to discussing security, performing backups and tuning, this is an exceptional book broken up logically and smoothly into 6 parts and 18 chapters:

01. Intro

02. Installing MySQL

03. Using MySQL Monitor

04. Designing Databases

05. Basic SQL

06. Datbase Structures

07. Advanced Querying

08. More MySQL Goodies

09. Managing Users & Privileges

10. Backups & Recovery

11. Using An Options File

12. Configuring & Tuning The Server

13. Web Database Applications

14. PHP

15. PHP Application Case Study

16. Perl

17. Perl With MySQL

Read more ›
2 Comments 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
21 of 22 people found the following review helpful By CH on July 28, 2007
Format: Paperback Verified Purchase
As a new user of MySQL with no previous SQL experience I found this book extremely helpful. This book helped me get my project up and running in very little time. I was especially impressed that even though the examples in the book did not directly correlate to what I was trying to accomplish it gave me enough general knowledge of MySQL to easily put together my project.
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
21 of 25 people found the following review helpful By Matthew Clower on June 5, 2012
Format: Paperback Verified Purchase
I have been working with MySQL for about 6 years but never took the time to do any formal learning so I was looking for a book to "fill in the gaps". After seeing the Amazon.com ratings for this O'Reilly book I decided to try Learning MySQL.

This book was written about the time I started using MySQL and I'm very glad that I didn't read this book then. The book is extremely disorganized and never decides on a target audience. It lacks consistency and relies heavily on a website that is no longer available for supplemental materials. The book does contain some useful information but that information is far overshadowed by its negative features. It's hardly a book of learning and would be better described as a book of bad examples. That's on top of the frequent grammatical mistakes and incoherent explanations.

Chapter 2:
This chapter tries to cover every possible condition in installing the components of the LAMP stack used by the book. Not only was the information in Chapter 2 already outdated when the book was published but at 85 pages it's the worst chapter I've read in any book in a very long time. Coverage for Linux and Mac were poor and the book would be much better off if Chapter 2 was simply omitted. Unfortunately chapter 2 is referenced literally from every subsequent chapter.

The book is riddled with screenshots and example output received by the console. This alone adds probably 100 pages to the book. Not to mention the authors' tangents into the irrelevant and then adding references on top of those irrelevant topics.
Read more ›
4 Comments 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
10 of 12 people found the following review helpful By smudgedlens on December 5, 2007
Format: Paperback
I was really impressed with "Learning MySQL". I actually got into MySQL because I was interested in developing data-driven websites. Instead of just buying a book on PHP & MySQL, I thought I would start by focusing just on MySQL to develop a strong foundation on the database side. With that in mind, I felt like this book did a great job covering all bases (no pun intended...Alright, I put some thought into that one).

If you are completely new to databases, then this book is a good place to start - here's why:

1) Coverage of database concepts and design: This book doesn't just launch into the code stuff. It will teach you about database structure and relationships. It will give you some pretty straight-forward rules on how you should design your database with regards to what goes in what tables and how columns in the tables relate to each other (the actual data relationships).

2) History of SQL: Without going into too much detail, the book explains where SQL has come from and what you can expect from it now.

3) Explanation of SQL Syntax: This book does a great job breaking down the syntax of the SQL language and showing you the standard syntax for the various statements it presents.

4) Examples galore: Okay, so a lot of the examples are pretty useless, but they do what they need to - show you how things work. There are also some big examples that are used consistently throughout the book, so you can see your own development in how you interact with the data. There are SQL scripts that you can download from the O'Reilly website to import the tables and data directly into your database to follow along with the authors' examples.
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

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Learning MySQL
This item: Learning MySQL
Price: $29.48
Ships from and sold by Amazon.com

What Other Items Do Customers Buy After Viewing This Item?