Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Reviews > Books > Programming
User Name


Search · Register · Submit New Review · Download your favorite Linux Distributions ·

The Definitive Guide to MySQL
Reviews Views Date of last review
1 36537 06-19-2005
Recommended By Average Price Average Rating
100% of reviewers None indicated 9.0

Description: This second edition of Michael Kofler's acclaimed MySQL book has updated and expanded to cover MySQL 4.0, the most recent production release of the popular open source database, which boasts more than 4 million users worldwide.

Like the first edition, this revision, which has been renamed to reflect the breadth and depth of Kofler's coverage of the topic, provides a thorough introduction to the installation, configuration, implementation, and administration of MySQL. In addition, Kofler demonstrates how you can use MySQL in conjunction with various other technologies to create database-driven websites, and he gives practical advice on database design. Kofler also covers what's coming up next in MySQL 4.1.

The Definitive Guide to MySQL, Second Edition is an irreplaceable resource for MySQL novices and experts alike.
Keywords: MySQL SQL LAMP database administration
Publisher: Apress
ISBN: 1590591445

Post A Reply 
Old 06-19-2005, 03:29 PM   #1
Registered: Jun 2001
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation:
Would you recommend the product? yes | Price you paid?: None indicated | Rating: 9

Pros: very good allround coverage of MySQL and how to use it
Cons: none i could see

So often, books on any given programming language, database or suchlike, take a strict line on what is deemed to be suitable for inclusion. Often this can be understandable given the potentially huge breadth of what this could be, so many OSes to over and some many other ways to use the product in question once it's core functionality is covered. Michael Kofler's definitive Guide to MySQL takes that challenge on, touching pretty much every likely way people will use SQL.

The book is split into two main areas, Fundamentals and Programming. Each doing admirable justice to its objectives.

The basic principles of MySQL is covered though the near 300 pages of the Fundamentals section. We get a reasonably standard grounding in the basics of the SQL language, including a responsible discussion on the limitations of MySQL, primarily it's areas of non-compliance to the ANSI SQL92 standard, something that's bitten me too many times in the past.

And so it comes to pass that by about page 230 you have been given a lot of really comprehensive advice about every part of the core SQL language with suitable examples and applications aplenty, in addition to good adherence to SQL best practises such as table normalisation.

The rest if Fundamentals takes us onto basic administration tasks, to provide the bread and butter foundations of any DBA's knowledge: both theory and practise of topics including transactions, security, backups, data import and export and others besides, and we've long since covered customized installations and configuration way back in the Introduction.

For me it's put a tick next to everything I'd have on my checklist for getting to know the insides of MySQL, but what about the outsides? How is MySQL going to help you and me in "real" world? Cue the second phase of this weighty tome: Programming.

As a moderator of, I'm used to people asking how they actually do something with MySQL, or any other database on Linux. Maybe they've done some Access work in windows, and got the hang of SQL (or rather, a very "interesting" version of) and are not ware of how a real database operates. From page 373 onwards is going to be the answer to anyone's question, you've just got to find it.

Thanks to the rise and rise of the Great Big InterWeb, and LAMP with it, PHP is the main focus of programming literature. In really good detail we're shown what libraries exist to allow the M and the P to do business, how to use the basic API functionality, and sizeable examples to go with them. Rather than the somewhat typical experience of having one pretend business be battered into submission to demonstrate every API call, we have two short and succinct case studies: a Library (OK, it is still books... but it's too easy not to I guess!) and also a basic Web forum. Each example sets out it's manifesto and goes and does everything it says it will. We're then offered a number of extensions to implement should they take your fancy.

Whilst PHP takes the lions share of the section, we are, in no uncertain terms, given a more than able grounding in Perl, Java, JSP, C, C++, VB and more generic ODBC interactions. Really not much more you could ask for if this is your first taste of MySQL, ehh?

This is a great book, really nice to see the author going for something of a holistic approach to the subject of MySQL. I have to say that this is wholly recommended for any new and fair-to-middling user. Or at least it will be until MySQL 5.0 settles in, and then Iíll be waiting for the third edition, and a much smaller Limitations section.


All times are GMT -5. The time now is 02:57 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration