Programming Books C Java PHP Python Learn more Browse Programming Books

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $7.82 Gift Card
Trade in
Kindle Edition
Read instantly on your iPad, PC, Mac, Android tablet or Kindle Fire
Buy Price: $19.79
Rent From: $9.58
More Buying Choices
Have one to sell? Sell yours here

Learning MySQL [Paperback]

by Seyed M.M. (Saied) Tahaghoghi, Hugh Williams
4.1 out of 5 stars  See all reviews (23 customer reviews)

Buy New
$32.49 & FREE Shipping on orders over $35. Details
In Stock.
Ships from and sold by Gift-wrap available.
In Stock.
Rented by RentU and Fulfilled by Amazon.
Want it Monday, April 28? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition
Rent from
Paperback $32.49  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

November 21, 2006 0596008643 978-0596008642

Whether you're running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you'll find the MySQL database engineuseful for answering questions such as:

  • Which are my top ten fastest-selling products?
  • How frequently does this person come to our facility?
  • What was the highest, lowest, and average score of the team last season?

MySQL, the most popular open-source database, offers the power ofa relational database in a package that's easy to set up andadminister, and Learning MySQL provides all the tools you need toget started. This densely packed tutorial includes detailedinstructions to help you set up and design an effective database,create powerful queries using SQL, configure MySQL for improvedsecurity, and squeeze information out of your data.

After covering the basics, the book travels far into MySQL'ssubtleties, including complex queries and joins, how to interact withthe database over the Web using PHP or Perl, and importanthouse-keeping such as backups and security.

Topic include:

  • Installation on Linux, Windows, and Mac OS X
  • Basic and advanced querying using SQL
  • User management and security
  • Backups and recovery
  • Tuning for improved efficiency
  • Developing command-line and web database applications using thePHP and Perl programming languages

The authors, Saied Tahaghoghi and Hugh E. Williams, have careers inacademia and business, and share a keen interest in research intosearch technologies.

Whether you've never touched a database or have already completedsome MySQL projects, you'll find insights in Learning MySQLthat will last a career.

Frequently Bought Together

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

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

Product Details

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

More About the Authors

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

Customer Reviews

Most Helpful Customer Reviews
36 of 40 people found the following review helpful
5.0 out of 5 stars MySQL Class In A Book April 18, 2007
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 ›
Was this review helpful to you?
21 of 22 people found the following review helpful
5.0 out of 5 stars Excellent starting point for a new user 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?
13 of 15 people found the following review helpful
1.0 out of 5 stars Terrible Book 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 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 ›
Was this review helpful to you?
10 of 11 people found the following review helpful
5.0 out of 5 stars Good book for an absolute beginner December 5, 2007
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?
Most Recent Customer Reviews
4.0 out of 5 stars book arrived and looked good
Took a little more time than I thought it would but it got to me and looks great when it arrived
Published 2 months ago by Lyle Rich
5.0 out of 5 stars Great resource
This is a great book. I bought it many years ago, and I picked it up recently and found it to be the best book available for me to find a topic that I could not find well-reviewed... Read more
Published 6 months ago by Richard C. Phillips
5.0 out of 5 stars Very informative
The book assumes you are a novice with SQL and takes you through well designed examples with increasing levels of complexity. The examples are thorough and build upon one another. Read more
Published 12 months ago by Donald Bryant
2.0 out of 5 stars Can't get into it
For some reason this book just doesn't answer my problems at all. I haven't finised it, probably won't. Odd for an O'Reilly...
Published 12 months ago by Will Guthrie
5.0 out of 5 stars One of the best tech books I've ever read
I have 31 years experience as a code developer for large corporations with some database work but limited HTML and no MySQL or PHP. Read more
Published 13 months ago by David M. Williams
4.0 out of 5 stars Gave me a good leg up to MYSQL
I have had some experience with SQL in the past but Hugh Williams book has been invaluable to using this product.
Published 16 months ago by Mr. A. J. Tretheway
5.0 out of 5 stars Top Notch Writer & Publisher
The book is terrific. It starts from the basics, establishes a foundation, then begins to build up from there. Read more
Published on January 26, 2012 by CompUSmart
4.0 out of 5 stars A good starting point
This book is divided into two principal parts. The first covers installing MySQL, some principles of database schema design, and the syntax of all the SQL statements that most... Read more
Published on January 22, 2011 by Tech Ed
5.0 out of 5 stars it was nice business deal
business experience with seller was good. there was not any kind of problem. book arrived in timely fashion.
I recommend doing business with this seller.
Published on October 10, 2010 by Diligent
5.0 out of 5 stars 100% Recomendado
Soy de Mexico y la verdad es que la calidad del producto ha sido realmente satisfactoria, y en cuanto al servicio de envio mas que excelente.
Published on August 18, 2010 by Puchef
Search Customer Reviews
Only search this product's reviews

What Other Items Do Customers Buy After Viewing This Item?


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category