The Definitive Guide to MySQL 5, Third Edition (Paperback)

by Michael Kofler (Author)
Key Phrases: foreign key constraints, web application, client tools, Visual Basic, Query Browser, Done Figure (more...)

Editorial Reviews

Product Description
"For those with a need to know, and those with a desire to learn MySQL, this volume contains nearly everything you would want and expect, not only about MySQL itself but about the software that interacts with it or web servers." — John Suda, Slashdot Contributor

"I've seen the 2nd edition (of) this book and it's good stuff." — Arjen Lentz, MySQL Community Journal MySQL 5 is slated to be the most significant release in the product’s history. The Definitive Guide to MySQL 5, Third Edition, is the newest revision of Michael Kofler’s popular book. This is the first book to offer in-depth instruction about the new features of the world’s most popular open source database server. Updated to reflect changes in MySQL version 5, this book will expose you to MySQL’s impressive array of new features: views, stored procedures, triggers, and spatial data types. Whether you’re a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security. You will also be introduced to several standard and third-party tools, like MySQL Administrator, Query Browser, and the popular PHPMyAdmin tool.

About the Author
Michael Kofler

Michael Kofler holds a Ph.D. in computer science from Graz Technical University. He has written a number of successful computer books on topics such as Visual Basic, Visual Basic .NET, and Linux. Michael is the author of The Definitive Guide to MySQL 5, Third Edition and Definitive Guide to Excel VBA, Second Edition from Apress.

Product Details

• Paperback: 784 pages
• Publisher: Apress; 3 edition (September 23, 2005)
• Language: English
• ISBN-10: 1590595351
• ISBN-13: 978-1590595350
• Product Dimensions: 9 x 7 x 1.5 inches
• Shipping Weight: 2.7 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars See all reviews (26 customer reviews)
• Amazon.com Sales Rank: #338,049 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #100 in

  Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL

Customer Reviews

Most Helpful Customer Reviews

54 of 56 people found the following review helpful:

5.0 out of 5 stars many samples, compact SQL reference, up to date, July 19, 2001

By A Customer

This review is from: MySQL (Paperback)

what I liked most at this book is the sample-oriented approach: the books starts with the setup of a WAMP/LAMP system; in the next chapter, the first 'real' application is presented: a simple web opinion poll (using PHP); thus, after only 80 pages I had a running test environment and my first application to work with

examples are also omnipresent in the following chapters: the chapter on MySQL user interfaces explains how to configure and use phpMyAdmin; relations, normalization and other ideas of good database design are explained by showing the design process for two databases (a books database and a database for a discussion forum); the chapter on SQL shows how to query these databases;

next is programming: the book explains how to build MySQL applications using PHP, Perl and VB (all databases and samples are available for download at the author's website)

the book also covers new MySQL features which have been added only recently: transactions with BDB, InnoDB and Gemini, full-text queries etc.

perhaps the only shortcoming is in the programming part: while the author covers PHP, Perl and VB (via ODBC), he mentions neither Java nor C/C++

overall, this is by far the most useful and up-to-date MySQL book I know of

51 of 53 people found the following review helpful:

5.0 out of 5 stars Great Resource - one of the best, April 26, 2004

By	Harold McFarland (Florida) - See all my reviews (TOP 50 REVIEWER)    (REAL NAME)

This review is from: The Definitive Guide to MySQL, Second Edition (Paperback)

Fully updated to include information on MySQL 4.0 and 4.1 "The Definitive Guide to MySQL, Second Edition" is one of the most through and yet easily understandable texts on MySQL available. The author assumes no previous knowledge of SQL or even database theory and design so you really start at the beginning. In fact chapter five, database design, is one of the more lucid explanations of relational databases and design theory that I have read anywhere.

Another item that differentiates this book from others of the same genre is the inclusion of a chapter of SQL recipes. This chapter is basically a cookbook that takes the most common tasks you may need to accomplish with your MySQL database and provides a recipe to accomplish that task.

It includes coverage of InnoDB tables (very important in a multi-user environment) and many other items besides the usual installation, administration, and configuration items you would expect. Of course, if you are writing a MySQL application you will have to use some sort of programming language to write your program. In keeping with the OpenSource theme of the book it includes extensive coverage of PHP, Perl, Java, C, C++, Visual Basic, C#, and ODBC. The book does not pretend to teach any of these programming languages but provides the information to use them with MySQL if you know that particular language. As a regular user of PHP, Perl, Visual Basic, and ODBC connections I found the coverage to be excellent, including everything you need to know to connect to the database and do whatever you need.

The book ends with an excellent reference section, a section on MySQL Tools, and even a section an API reference. In short it is one of the most exhaustive books on the subject and provides everything for a new user as well as complete reference coverage for an experienced user, programmer, or administrator. "The Definitive Guide to MySQL, Second Edition" is highly recommended for anyone interested in learning, administering, or programming MySQL.

64 of 69 people found the following review helpful:

5.0 out of 5 stars Saved my you-know-what, February 27, 2003

By	Ms. Mary R. Sweeney "M. R. Sweeney 'book lover" (Issaquah, WA United States) - See all my reviews (REAL NAME)

This review is from: MySQL (Paperback)

I committed to doing a MySQL project because it was less expensive overall for my client than using software I'm more familiar with (I'm not naming names but let's just call them SQL Server and .Net). I'm very experienced creating databases but brand new to MySQL and PHP. I don't know how I would have survived without Kofler's book. He not only explains everything step-by-step but in a very relevant, clear way. I had several other books in my arsenal and found I dropped all of them when I needed to look something up and just used Kofler all the way. Everything I needed to do, he had an example for in his demo files!

I know from experience how frustrating it can be not to have the right resources available. Although there are some great user's groups and so on, Kofler's book saved me a ton of time because I found pretty much everything in his book. Using his book and the free, on-line PDF MySQL manual is all you'll need to do a complex business application for the web.

Thanks Kofler. You're my hero!