General MySQL Reference Books

These reference books are about all or nearly all of MySQL. There may be some specialized topics that are not included, but they cover the aspects of MySQL which are common to almost developers and administrators of MySQL. This grouping of books are primarily reference books, organized similarly to a dictionary. They may include brief tutorials and examples, but weren’t intended to be read in page number order. Instead, you use them to look for information as you need it on a particular SQL statement or function.
 
MySQL in a Nutshell
  • edition: 2nd
  • author: Russell J.T. Dyer
  • published: 2008
  • isbn: 978-0-596-51433-4
  • pages: 561
MySQL statements and functions are grouped by usage and from there they are listed in alphabetical order. For each statement and function, the syntax and explanation is provided along with examples of their use. Since the author is intricately involved in this web site, we'll leave it to others to comment further on this book.
 
MySQL Cookbook
  • edition: 2nd
  • author: Paul DuBois
  • published: 2007
  • isbn: 978-0596527082
  • pages: 975
For many years now Paul has been providing advice when he can to users posting questions on MySQL sites. Paul has used these interchanges to build this excellent book of common tasks and solutions to common problems.
 
Beginning MySQL Database Design and Optimization: From Novice to Professional
  • edition: 1st
  • author: Jon Stephens
  • published:
  • isbn: 978-1590593325
  • pages:
 
MySQL
  • edition: 4th
  • author: Paul DuBois
  • published: 2008
  • isbn: 978-0672329388
  • pages: 1224
One of the first writers on MySQL, Paul DuBois' primary book named simple MySQL is the most complete manual on MySQL you can buy.
 
Pro MySQL
  • edition: 1st
  • author: Jay Pipes
  • published: 2005
  • isbn: 978-1590595053
  • pages: 768
 
Definitive Guide to MySQL 5
  • edition: 3rd
  • author: Michael Kofler
  • published: 2005
  • isbn: 978-1590595350
  • pages: 784
 
MySQL (Visual Quickstart Guide)
  • edition: 2nd
  • author: Larry Ullman
  • Peachpit Press
  • published: 2006
  • isbn: 978-0321375735
  • pages: 480
 
MySQL Database Design and Tuning
  • edition: 1st
  • author: Robert D. Schneider
  • MySQL Press
  • published: 2005
  • isbn: 978-0672327650
  • pages: 432
 
MySQL Pocket Reference
  • edition: 2nd
  • author: George Reese
  • O'Reilly Media
  • published: 2007
  • isbn: 978-0596514266
  • pages: 132
This booklet is small in size, but lists alphabetically all of the MySQL statements and functions with the syntax and descriptions of each. It's a great book to keep in your bag or by your database server for quick reference.
 
MySQL Tutorial
  • edition: 1st
  • author: Luke Welling
  • MySQL Press
  • published: 2003
  • isbn: 978-0672325847
  • pages: 288

MySQL Replication

Whether you’re new to MySQL replication or have been using it for some time, you will find this new book useful. It will help you actually to understand MySQL replication so you can keep it running. It’s especially useful when replication stops and you can’t get it started again.