PHP Cookbook

MySQL (3rd Edition) (Developer's Library)

High Performance MySQL

Web Database Applications with PHP & MySQL, 2nd Edition

Sql

MySQL Cookbook

Format: Paperback
Author: Paul DuBois
ReleaseDate: November, 2002
Publisher: O'Reilly Media
Rating:

MySQL For Applications Server


Very good for students in their second or third semester of RDBMS studies. Excellent text well written and logical sequencing of chapters.

I do not recomend for beginning relational databse students.

Solves a lot of problems! (That's how it's organized)
( also referred to the O'Reilly Perl books _Programming Perl_ and _Perl for System Administration_. I had a recent perl+mysql project and flipped between the Cookbook and the author's other work, MySQL, mentioned in other reviews. I don't usually have time to master any topic or skillset; I need to get in, get it going, and move on. This book is perfect for that. "How do I get the date?" There's a recipe for that. "How do I get perl to connect to the database and insert stuff?" There's a recipe. Also for PHP, python, etc. It's really focused on problem solving, and the problems are really well chosen. This book will save you hours of effort. .

Lucky Me!
I especially like the `From Scratch` and `Cookbook` type titles. I am a big fan of hands-on books.

Well, lucky me. When I attended the 2005 MySQL Users Conference in Santa Clara CA in April '05, I received the "MySQL Cookbook" by Paul DuBois as a reward for early registration.

The day after I returned back to work from the conference, one of my co-workers came looking for some guidance in regards to a MySQL database issue he was having. His description sounded familiar to one of the recipes I skimmed in the cookbook. Sure enough, I found the resolution within two minutes, and had sent
another satisfied customer on his way.

The great aspect of this book is that it is written to provide solutions to over 315 real-world problems. Whenever I come up against an obstacle in regards to MySQL, I head straight to the table of contents and scan for a recipe that looks like it might be a match.

One topic I wish was covered somewhere in this text is the concept of derived tables, which are basically sub-queries used as tables in a join.

(. . . )
The "MySQL Cookbook" and "MySQL in a Nutshell" books are permanent fixtures in my office . . . except for when my co-workers borrow them.

-Brett Berry
PERL/PHP/JavaScript/MySQL
(. . . ).