The Definitive Guide to MySQL 5

by Michael Kofler

Book Overview

The Definitive Guide to MySQL 5, Third Edition is the latest revision to Michael Kofler's popular comprehensive book on the world's most popular open source database server. Updated to reflect the changes in MySQL version 5, the most significant update in the product's history, readers are exposed to MySQL's impressive array of new features including views, stored procedures, triggers, spatial data types, and more. Novice and intermediate users...

• Format: Paperback
• Language: English
• ISBN: 1590595351
• ISBN13: 9781590595350
• Release Date: October 2005
• Publisher: Apress
• Length: 784 Pages
• Weight: 2.75 lbs.
• Dimensions: 1.7" x 9.1" x 7.5"

Customer Reviews

The Best MySQL 5 Book Out there!

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.

perfect guide for database programmers

coming from the Visual Basic world (VB6, VB.NET), this book first helped me to use MySQL databases in my VB applications; later I had to make MySQL data available on the web and got used to PHP; again, Kofler's book provided excellent guideance in the various ways of interaction (mysql/mysqli) between PHP and MySQL in contrast to some other MySQL titles I had a look at, Kofler does not focus entirely on MySQL itself; he explains MySQL in context with the programming languages it is mostly used with (the book also covers Perl, Java and C; as I haven't used this languages yet, I cannot say whether these chapters are as good as those on PHP, VB and .NET)

It's kind of definitive.

My requirements for this book for quite light, so I can't say that I used it to its full potential, but I can say that it filled my requirements completely, and it clearly has so much more ready and waiting to show me in the future. Ranging from first steps with MySQL all the way up to the advanced features, 'definitive' is a good description for the book. I've always found that there are great MySQL resources on the web, but the layout of the book, clear descriptions and concise examples will give you a single location and unified view of anything you'll need. There isn't really any point mentioning individual sections. Readers experienced with other databases will find coverage for all of the sections they expect, and likewise new users will be provided the information they require. This is one of the few books I've seen that works for both picking up a new topic and as a reference for flipping to a specific section. I was a little concerned that it was written in another language and translated to English for this copy, but apart from some of the sample data in the examples this is never an issue. You won't find a better MySQL resource than "The Definitive Guide to MySQL"... until the next revision comes out!

The book I reach for

This is the best-written computer book I own. I use it constantly for the LAMP system we are learning and using; I know that when I turn to this book I will find what I need explained with clarity and felicity - to explain all of these topics in an almost casual way. I especially appreciate tips such as setting up a username/pw in an include file, and the other security tips. I go through these pages, try it on the linux, and it works. This book is as much fun as a novel, but leaves me with something entirely non-fiction. This is the book I reach for.

A Must for MySQL Developers and Administrators Alike

The Definitive Guide to MySQL is a thorough, yet easy to understand resource for enhancing your database skills and knowledge. This book isn't just another version of the MySQL documentation. It teaches the reader a great deal about relational database design and all of the options to consider beforehand, such as choosing a table type, when and where to use indexes, etc. The book also provides a solid understanding of administering a MySQL installation, exploring such topics as performance tuning, backups, replication, and upgrades.For those on the programming side, you will find information on creating applications using a wide variety of languages, including PHP, Perl, Java, C++, and Visual Basic, although PHP is the most extensively covered.Overall, I'd say Michael Kofler did an excellent job on this book. All of the examples and explanations are clear and concise. If you are simply looking for a quick MySQL function reference, stick with the documentation. However, if you want to really learn how to get the most out of MySQL, this book is a must.