MySQL

MYSQL in a Nutshell (In a Nutshell (O'Reilly))
$34.99
'MySQL in a Nutshell' is another solid release in the family of 'Nutshell' books by O'Reilly. As with all other Nutshell books, this isn't a learning book, moreso a shorter reference manual for experienced developers who know what they are using and need a guide to help them out through the process. With MySQL In A Nutshell you are getting exactly that. Spread over nearly 550 pages and 19 Chapters, here's an overview of the content within:

01. Introduction
02. Installing MySQL
03. MySQL Basics
04. Security, User Statements, Functions
05. Database And Table Schema Statements
06. Data Manipulation Statements And Functions
07. Table And Server Administration Statements And Functions
08. Replication Statements And Functions
09. Stored Routines Statements
10. Aggregate Clauses, Functions And Subqueries
11. String Functions
12. Date And Time Functions
13. Mathematical Functions
14. Flow Control Functions
15. MySQL Server And Client
16. Command-Line Utilities
17. C API
18. Perl API
19. PHP API

The layout is good, separation of data is intelligently laid out and the writing is solid. If you are a MySQL developer or admin that is looking for a resource by your side at all times this is a great book to have!!

***** RECOMMENDED

MySQL Cookbook
$49.99
I need to learn about MySQL for my small business. My son the computer tech said this was the book I needed to get me up to speed quickly. He was right. It's concise, apparently complete, and easy to understand, even if the subject is a bit mind-bending at times. Without a book like this, I wouldn't enjoy the learning experience; it would be less pleasant than another knee surgery.

This book is highly recommended by a guy who has read a lot of instructional material in a 40-year career that included service as a part-time college instructor...and by his adult son whose computer library cost his dad thousands of dollars.

High Performance MySQL: Optimization, Backups, Replication, and More
$49.99
How come I did not comment on this book before? Its been some time since I got it, read it, and used it! That's what this book is... useful, very useful. We had to optimize a DB, specially a huge table with millions of numbers and managed to go from tens of seconds to milisecs. I would say it was.. well, very useful;)

MySQL Stored Procedure Programming
$44.99
This book clearly covers stored procedure programming well. Of course, it goes over basic syntax and provides examples, but it also goes much farther than that. This book discusses optimization of MySQL queries regardless of the use - in or out of sprocs. It also did a very nice job of discussing the use of cursors - the ability to iterate through the results of a query without being pelted with the entire result set all at once.

If you're developing on MySQL 5 or greater, and you're serious about letting the database handle things that make sense (i.e. denormalization, administration, and putting business logic into the database), this is an excellent resource.

Hit(s):

o Thorough coverage of
- o stored procedures
- o functions
- o triggers
- o cursors
o Explains stored procedure optimization very well
o Serves as stored procedure cookbook
o Excellent coverage of stored procedure best practices
o Demonstrates use of stored procedures with languages like PHP, Perl, Java, and others.

Miss(es):

o Title doesn't do it justice.