MySQL (3rd Edition) [Paperback]

Paul DuBois (Author)

Book Description

Publication Date: March 18, 2005 | ISBN-10: 0672326736 | ISBN-13: 978-0672326738 | Edition: 3

A new edition of this title is available, ISBN-10: 0672329387 ISBN-13: 9780672329388

 

For years, MySQL has been helping MySQL developers and database administrators learn their MySQL system inside and out. This newest edition has been updated to include information on MySQL 5 and it will prove itself again to you as being the most definitive reference guide to using, administering and programming MySQL databases. You'll learn everything from the basics to using MySQL to generate dynamic web pages to administering MySQL servers. This edition has been reviewed by the top developers in the MySQL community and the changes reflect their feedback, as well as the feedback of many other readers, and it has turned out to be the most comprehensive, thorough edition of MySQL to date. Don't go to work without it!

 

 

Editorial Reviews

From the Back Cover

In the second edition of MySQL Paul DuBois provides an updated, comprehensive guide to one of the most popular relational database systems.

MySQL is the most popular open source database server in the world, with more than 2 million installations and customers including Yahoo!, MP3, Motorola, and NASA.

MySQL 4.0, now generally available, is a long-awaited update to the database management system that has many new features, including a new table definition file format, enhanced replication, and more functions for a full text search.

Instead of giving readers merely an overview of MySQL 4.0, DuBois continues to include the most sought-after answers to the questions he hears most often from the community. --This text refers to an out of print or unavailable edition of this title.

About the Author

Paul DuBois is a writer, database administrator, and leader in the Open Source community. He is currently a Senior Technical Writer at MySQL AB. In addition to MySQL, he is also the author of MySQL and Perl for the Web, MySQL Cookbook, Using csh and tcsh, and Software Portability with imake.

See all Editorial Reviews

Product Details

• Paperback: 1320 pages
• Publisher: Sams; 3 edition (March 18, 2005)
• Language: English
• ISBN-10: 0672326736
• ISBN-13: 978-0672326738
• Product Dimensions: 9 x 7.1 x 1.8 inches
• Shipping Weight: 3.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (40 customer reviews)
• Amazon Best Sellers Rank: #1,096,723 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

16 of 16 people found the following review helpful:

5.0 out of 5 stars In depth look on MySQL, March 24, 2004

By 

Gabor Hojtsy - See all my reviews

This review is from: MySQL (2nd Edition) (Developer's Library) (Paperback)

This book is not for beginners, or at least not for those coming from the GUI world without command line experience. Paul makes heavy use of the command line for his examples, and the book in fact contains a large amount of reference content on the command line tools you can use.

That said, the majority of the book is written in a well explained fashion, even the reference part at the end has lengthy explanations, so you will always find what you need. The reference section would be the ideal place to look at for type info, function parameters, etc. if the book would not be that heavy, but the precise explanations would not be possible otherwise.

This book tries to be everything for everybody, which is hard to accomplish. The first section provides an introduction to SQL, but there is also significant info for system administrators and a huge amount of pages on programming with C, Perl and PHP in connection with MySQL. If you are a beginner, and you are not interested in having your own server, or writing C programs, then this book might not be the best choice. However, if you would like to have a broad overview with details wherever you need, this book is advisable.

20 of 22 people found the following review helpful:

4.0 out of 5 stars Great as a reference / advanced text, August 23, 2004

By 

A. justo Perez (Asturies, Spain) - See all my reviews
(REAL NAME)   

This review is from: MySQL (2nd Edition) (Developer's Library) (Paperback)

I was already developing mysql & php sites and apps when i purchased this book, so it was a good buy as a reference text, but if you intent to learn Mysql, there are better books than this one.

It is deep, slow to read, with rather small text size. For the beginner, i think it's not a good starter. But on the other hand it has almost everything you would want to know about Mysql, with lots of examples and quite well explained.

I learned Mysql and PHP from Sam's "Php and Mysql web development", and i couldn't recommend that one enough. It's a GREAT text for the beginner. I found myself writing Php/Mysql web sites in less than 3 months, starting from nothing.

14 of 15 people found the following review helpful:

5.0 out of 5 stars Outstanding organization and lucid prose, July 11, 2003

By A Customer

This review is from: MySQL (2nd Edition) (Developer's Library) (Paperback)

I had little experience with database creation and maintenance prior to my current project. In fact, I had been putting off getting involved in any database projects for fear of the learning curve. I'm midway through the project now, and DuBois' guide has been indespensible throughout.

Highlights:
* chapter organization -- starts with a tutorial on basic usage of MySql, and relegates installation guidance to an appendix. Too often such texts mix usage and administation in a chaotic jumble.
* comprehensive index -- I've yet to fail in finding a topic at the first entry I've searched.
* appendices (MySQL operators and datatypes, SQL, C and Perl api references) -- due to the size of this volume, these handy reference sections can be hard to thumb to, unless you glue in some post-its like I did, but they're worth finding for quick, clear descriptions of total Mysql usage.
* prose -- Terse (despite the volumes' 1200 pages), clear, and well-organized.
* author's background -- DuBois' close involvment in the ongoing efforts of the MySql project have given him a vast knowledge of the arcane differences in versions and operating systems as well as upcoming features. The 2nd edition is very uptodate at of mid-summer 2003.

MySql, BTW, has not disappointed.