Error message

Strict warning: Declaration of views_handler_field_amazon_participant::pre_render() should be compatible with views_handler_field::pre_render(&$values) in require_once() (line 3 of /var/www/mysqlresources-drupal/modules/amazon/includes/

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

  • author: Russell J. T. Dyer
  • edition: 2
  • publisher: O'Reilly Media
  • list price: $34.99
  • price: $12.12
  • year: 2008
  • pages: 566
  • isbn: 9780596514334
  • overall rating:
  • skill level:
  • technical level:

If you work with MySQL regularly and need a book on the topic with an easy to follow writing style and helpful examples, consider buying MySQL in a Nutshell. If you already have the first edition, the second edition recently came out: it’s much better than the first edition and has had some great reviews.

MySQL Cookbook

  • author: Paul DuBois
  • edition: Second
  • publisher: O'Reilly Media
  • list price: $49.99
  • price: $28.35
  • year: 2007
  • pages: 980
  • isbn: 9780596527082
  • overall rating:
  • skill level:
  • technical level:

For many years now Paul Dubois 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. It's designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.

Book Review:


  • author: Paul DuBois
  • edition: 5
  • publisher: Addison-Wesley Professional
  • list price: $54.99
  • price: $34.60
  • year: 2013
  • pages: 1,176
  • isbn: 9780321833877
  • overall rating:
  • skill level:
  • technical level:

One of the first writers on MySQL, Paul DuBois' primary book named simply, MySQL is the most complete manual on MySQL you can buy. He describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers. The book also includes a comprehensive reference section providing detailed information on MySQL’s structure, language, syntax, and APIs.

MySQL Workbench: Data Modeling & Development

  • author: Michael McLaughlin
  • edition: 1
  • publisher: McGraw-Hill Education
  • list price: $45.00
  • price: $28.44
  • year: 2013
  • pages: 480
  • isbn: 9780071791885

This book helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The book covers the interface and explains how to accomplish each step by illustrating best practices visually.

Expert MySQL

  • author: Charles Bell
  • edition: 2nd ed.
  • publisher: Apress
  • list price: $59.99
  • price: $39.22
  • year: 2012
  • pages: 640
  • isbn: 9781430246596

This book is a great reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is for systems integrators, engineers, and software developers working with the MySQL server code.

Murach's MySQL

  • author: Joel Murach
  • publisher: Mike Murach & Associates
  • list price: $54.50
  • price: $54.50
  • year: 2012
  • pages: 612
  • isbn: 9781890774684

This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling "Java Servlets and JSP" and "PHP and MySQL" books, this is exactly the database book that web developers should have on their desks.

MySQL Admin Cookbook

  • author: Daniel Schneller, Udo Schwedt
  • publisher: Packt Publishing
  • list price: $49.99
  • price: $49.99
  • year: 2010
  • pages: 376
  • isbn: 9781847197962

This book uses the approach of a cookbook, presenting solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy.Administrators of all skill-levels will find step-by-step instructions for practical approaches to MySQL configuration, maintenance, and optimization topics. Each recipe uses a concrete example for easy understanding.

MySQL Database Usage & Administration

  • author: Vikram Vaswani
  • edition: 1
  • publisher: McGraw-Hill Education
  • list price: $53.00
  • price: $42.20
  • year: 2009
  • pages: 368
  • isbn: 9780071605496

Maximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. MySQL Database Usage & Administration includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook.

MySQL Administrator's Bible

  • author: Sheeri K. Cabral, Keith Murphy
  • edition: 1
  • publisher: Wiley
  • list price: $60.00
  • price: $42.27
  • year: 2009
  • pages: 888
  • isbn: 9780470416914

This book provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions.

MySQL Pocket Reference

  • author: George Reese
  • edition: 2
  • publisher: O'Reilly Media
  • list price: $14.99
  • price: $14.60
  • year: 2007
  • pages: 134
  • isbn: 9780596514266

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.