MySQL (5th Edition) (Developer's Library) and over one million other books are available for Amazon Kindle. Learn more
CDN$ 32.59
  • List Price: CDN$ 51.99
  • You Save: CDN$ 19.40 (37%)
Only 8 left in stock (more on the way).
Ships from and sold by
Gift-wrap available.
MySQL (5th Edition) has been added to your Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

MySQL (5th Edition) Paperback – Apr 2 2013

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
CDN$ 32.59
CDN$ 32.59 CDN$ 30.00 First Novel Award - 6 Canadian Novels Make the Shortlist

Frequently Bought Together

MySQL (5th Edition) + High Performance MySQL: Optimization, Backups, and Replication
Price For Both: CDN$ 75.81

Buy the selected items together

Product Details

Product Description

About the Author

Paul DuBois is a writer, database administrator, and leader in the open source and MySQL communities. He has contributed to the online documentation for MySQL and is the author of MySQL and Perl for the Web (New Riders), MySQL Cookbook, Using csh and tcsh, and Software Portability with imake (O’Reilly). He is currently a technical writer with the MySQL documentation team at Oracle Corporation.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) 16 reviews
19 of 20 people found the following review helpful
Best single MySQL Book you can buy!! June 3 2013
By David M. Stokes - Published on
Format: Paperback
MySQL by Paul Dubois recently was reissued in a fifth edition. I purchased my first edition of this book more than a dozen years ago and it has become heavily dog-eared, festooned with Post-Its, and hand annotated over the years. It has proven to be the `go-to' book when other books or the manuals did not explain to my satisfaction any questions that have popped up.
The author is part of the amazing MySQL Documentation Team for Oracle and certainly knows the subject. At 1,154 pages it is not light in weight nor light in detail. The chapters include `Data Types', `Writing MySQL Programs using C', `Security and Access Control', `System, Status and User Variable Reference', `Query Optimization', `Writing MySQL Programs using PHP', and `The MySQl Data Dictionary'. The layout is easy on the eyes and the examples are able to spotlight the idea being covered fully. The text itself reads easily and amazingly clear. This is the most complete single book on MySQL and the one book you would bring if you have to use MySQL on the fabled desert island that allows only one book. The book is detailed enough for gnarled DBAs to discover undiscovered gems while clear enough for a junior MySQL-er to be able to get through a rough spot.

if you run across this book in a store, head directly to chapter 13 on Security and Access Control where `How to Steal Data' provides any DBA a Steven King level horror story that will provide nightmare fodder for years to come. The author then guides you through MySQL security and provides the best details on Proxy Accounts I have found. Other chapters are equally profound and perfectly detailed.

It does cover some of the new features of MySQL 5.6 but 5.6 came out after this book was committed to publishing. This is a minor problem and should not stop anyone from getting a copy of this book in their hands ASAP.

And I apologize to Paul and his publisher for what I will do to this book in the next few years as I make notes, add Post-Its, fold corners on certain pages. This is a physically beautiful book that will look like a sea anemone as I make good use of it.
6 of 7 people found the following review helpful
Good introduction for beginner dev/dba + offline reference manual Aug. 1 2014
By AmirBehzad Eslami - Published on
Format: Paperback
This book serves as an "introduction" to MySQL, addressing developers and DBAs. It can also be used as an offline reference manual. In fact, it is more similar to a tutorial, accompanied with hundred pages of SQL reference and appendix chapters, repeating online stuff that you can find online on official MySQL manual, as another reviewer has mentioned.

The first two chapters provide a gentle overview of MySQL for developers. Practicing the examples can upgrade the reader from a newbie to an intermediate MySQL user. The author uses a sample InnoDB database to demonstrate CRUD operations in MySQL, its SQL syntax, elements of its DDL & DML statements, transactions, indexing, and query optimization. JOINs are discussed very well, with interesting examples. I learned a few new stuff from these chapters, such as tuples, the <=> operator, and multi-table delete.

It does not introduce MySQL Workbench, the user-friendly GUI for MySQL, and heavily relies on the text-based mysql terminal monitor throughout the book.

There are a few chapters on administration, covering installation, access control, backups, and maintenance. Again,
this is basic stuff, and for serious administration, you'll need to consult advanced books (check below).

This book does not cover advanced topics in depth, such as parameter tuning, replication, stored procedures, MySQL internals, etc. It does not talk about performance schema, NDB, NoSQL memcached API, MySQL Proxy at all. You'll find random tips and tricks when you skim through the pages, but it's not a cookbook.

More than 200 pages are devoted to MySQL API for C, PHP, and Perl.
I don't like author's choice of languages either. More than 300 pages are devoted to SQL syntax and different CLI options for mysql client programs, it's a waste of paper when you can easily produce the same thing via "--help".

If you're new to MySQL, this book is for you. Beginners will take much benefit from this book.
But if you're a seasoned MySQL dev/dba, and you know MySQL and its features, you won't find new stuff here.
Instead, have a look at "MySQL Cookbook, 2014" from the same author, "High Performance MySQL, 3rd Ed", "MySQL High-Availability, 3rd Ed", and "MySQL Troubleshooting" from O'Reilly.
3 of 3 people found the following review helpful
Perfect reference for MySQL March 9 2014
By DJ Far - Published on
Format: Paperback Verified Purchase
Just what I was looking for - not something to read, but something to grab when you need to dig in depth a bit more than a quick google search. Well laid-out, good TOC and index.
By the way, Amazon, in your book listings you should publish the Index section of every reference book in the Preview. Some indexes in reference books are horrible, or missing. That can render an otherwise decent book useless, as far as I'm concerned.
10 of 13 people found the following review helpful
Standard July 23 2013
By Rabih - Published on
Format: Paperback Verified Purchase
The defacto standard in MySQL references. The one comment I would have for this book would be to make the examples a little more relevant. No one is going to code MySQL straight through the terminal. Give some info on the GUI-based systems.
4 of 5 people found the following review helpful
MySQL Bible Aug. 29 2013
By Leslie Johnson - Published on
Format: Paperback
In the net I found the book invaluable in understanding the inner working of MySQL for designing and building my database. This I'll keep it close at hand as I flesh out the structural details of my database and set to work at my keyboard. Later on it will serve as a primary reference on SQL syntax and query structure.