The book opens with an introductory database example (Chap 3), an opinion poll. The author spends nearly a page in his attempt to justify why MySQL is more suited to his example than a text file. This justification is not only uneccessary but outright wrong. The sample SQL also contains a glaring error that is likely to confuse the newer MySQL user

"In order to generate a table with the two columns /id/ and /choice/, the following command would suffice: CREATE TABLE votelanguage (id INT, choice TINYINT, ts TIMESTAMP);". If you are new to MySQL, you may be wondering about "ts TIMESTAMP".

At every page I have turned to and begun to read, I have found at least one similarly minor/distracting error: "changes in boldface" followed by lines of code with no boldface, "the following will insert a data record with a value of 4: INSERT into t VALUES (3)", etc, etc, etc...

There are numerous sections of text that are terribly written, almost as though they have been badly translated from another language. Chapter 4, for instance, opens with "The end user should never see MySQL as a program. Instead, a convenient program or several web sites should be used to provide access to the database, assist in the input of new data and execute backups
"For such tasks, you can use the commands mysql, mysqladmin and mysqldump ...". Presumably he mean't that these commands are not the interface through which the typical user will see MySQL.

I said the book is not definitive - I say this because its focus is incredibly broad. It covers a wide spectrum of MySQL-related topics, primarily dealing with specifics of language interfaces (by sheer volume of pages). It covers nothing in true depth (with several item specific chapters containing the "Tip" that "In this chapter you will learn about /this/ only superficially. However, ... will be described elsewhere in the book ..."

Every time I open this book, I find errors or cryptic paragraphs that I have to deconstruct in order to understand the author's point. Often times, even when the author is quite clear, I find his points to be in error. For example, returning to the initial opinion poll: the author implies that if your result set were merely the vote option and number of votes for that option, it would be simplest to just store that in a single file. But if you wanted to store individual votes or comments or IP addresses, you would need MySQL!

Infact, due to concurrency issues, MySQL would be far better suited to the simple tally counter.

'The Definitive Guide to MySQL 5' by Michael Kofler is in its 3rd Edition for the simple reason that this is a GOOD reference book. Jam packed full of nearly 750 pages worth of excellence, this book isn't just a reference manual, but a learning TOOL as well. The glowing reviews for this book are not without a legit reason, this is a wonderful guide that belongs on the desk of any and all MySQL developers. Pick up this book to learn and excel... you won't be disappointed!!

***** HIGHLY RECOMMENDED

This book is indeed a valuable resource for those who wish to have a deep understanding and interoperations of MySQL. However, by no means believe this book is for a MySQL beginner. I am college educated and frequently self-teach on many topics within the technical field. I bought this book with the hopes of getting a foundational understanding of MySQL and have a database up and running in the first few chapters. The first chapter does carefully explain what a relational database is, its features, and limitations, but then gets lost into the murky realm of administrative tools, user interfaces, and database design. The book finally gets around to giving the reader the first command to creating a database on page 268 (chapter 11). By this point the author gives the impression that getting a database started just a formality rather than the start of something fun and exciting. (Am I crazy for thinking databases are fun?)

In general, I found this book a hard read. It's very dry and in my opinion, not well laid out. This book is for someone who already has foundational knowledge in MySQL and some programming. The author seems to have a thorough understanding of the topic, but is not good at teaching to underlings such as myself. I'm not going to toss the book, but keep it on my shelf as a reference. In the mean time I need to find another book on MySQL.

This is bar-none the best MySQL (all-inclusive) book I've ever used. I've been using MySQL for about 5-6 years (maybe longer I've lost count). In projects from Personal stuff to Commercial and Corporate sites. I feel like I know a lot about MySQL simply by using and Admin'ing it for most of this time. I've learned a great deal from "The Definitive Guide to MySQL 5" and am making immediate use of several things that have made significant improvements to the current project I'm working on...and has given me ideas as to how to improve on a few sites I didn't think I could improve much on.

I would recommend this book for ANYONE interested in MySQL 5. It's well organized, and provides enough information to use virtually anything related to MySQL 5.

Thanks to Michael Kofler for such a well written and organized book!

The only things I would have preferred just a tad more detail on is the use of Cursors in Stored Procedures. Aside from that this is an EXCELLENT resource I highly recommend.

This book is great for anyone getting started with MySQL. The book does an excellent job of helping the reader learn MySQL on both Windows and Linux systems, with most examples being run in tandem across both platforms. The books review of MySQL administration tools and clients is very in depth, and probably the best single-source coverage I have seen on the topic.

The chapter on integrating MySQL with OpenOffice and MS Office is unique to this book, as far as I know and I think several readers will get their money's worth simply from that. Using MySQL as a productivity tool instead of a programming tool changes the approach for several MySQL users.

The fundamentals section of the book, which includes DB design, security and some of the newer features of MySQL (stored procedures and triggers) is a very nice overview, even for seasoned MySQL users. The administration chapter is probably my favorite, as I am a System Admin. This chapter provides examples and instructions about backups, migrations, performance tuning and replication.


The final section on programming was a nice introduction to programming with/against MySQL, but was brief for nearly all topics, but understandably so. There are dozens of books on PHP and MySQL alone, so a few chapters on PHP, Perl, Java and VB are good introductions, but other material should be sought after for an in-depth project.

All in all the book is very thorough, and makes an excellent addition to Apress's Open Source line of books.