Today I finally recieved my copy of
MYSQL - The complete Reference by
Vikram Vaswani, author of "
XML and PHP" and several tutorials over at
Devshed.
The book deals with everything you ever wanted to know about MySQL but were afraid to ask, starting with a very short introduction to databases in general and the architecture of MySQL. The Vikram talks about MySQL installation and configuration before he shows you how to actually use MySQL in the second part of the book.
He explains SQL basics as well as
all functions, datatypes and operators that MySQL provides. This part of the book also explains newer features of MySQL like subqueries and transactions. Part 3 of the book focuses on the administration of the database server and delves into security issues as well as performance optimization and the replication features of MySQL.
The last part is for developers that want to use MySQL from their applications and explains the MySQL API for C, Perl and of course PHP.
I'll post an in-depth review as soon as I've finished reading, but at a first glance the book looks excellent, like Vikram's other work.