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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.