REVIEW - The Definitive Guide to MySQL


The Definitive Guide to MySQL


Michael Kofler



Apress (2004)




Christopher Hill


August 2004



Riding on the coat tails of the latest trend we have yet another book on MySQL that extensively covers installation of MySQL on a number of platforms, database design and the SQL language from a MySQL point of view, and finally how to use MySQL in various programming languages.

While I get the impression that the author knows the subject well, he has not been well served by the translation, which is quaint at best and very confusing at worst - two examples "Extraordinarily frustrating was the attempt to install both packages under Windows", and "However, if you wish to allow, for example, that in the book database a book could be entered that had no publisher, then you should do without NOT NULL".

In Part II the author addresses database design, SQL and using PHP as the programming language; not in three separate chapters, but interspersed with much cross-referencing. I have used PHP and MySQL for a few years now, but I found the presentation very confusing. This was not helped by the code examples not matching the resulting output, or that were incomplete. I also worry about code examples that show poor practice - one example was issuing a query within a for loop to retrieve records with keys 1 to 6.

Part III romps through Perl, Java, C, C++, Visual Basic C# and ODBC. These chapters are mainly how to install the components and to get a simple "Hello MySQL" example running. These fall into the chasm of too much information for the expert and insufficient for the novice.

Not recommended.

Book cover image courtesy of Open Library.

Your Privacy

By clicking "Accept Non-Essential Cookies" you agree ACCU can store non-essential cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

Current Setting: Non-Essential Cookies REJECTED

By clicking "Include Third Party Content" you agree ACCU can forward your IP address to third-party sites (such as YouTube) to enhance the information presented on this site, and that third-party sites may store cookies on your device.

Current Setting: Third Party Content EXCLUDED

Settings can be changed at any time from the Cookie Policy page.