Product Description

The Definitive Guide to Using, Programming, and Administering MySQL 5.0 and 5.1

 

MySQL is an open source relational database management system that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications.

 

In MySQL, Paul DuBois provides a comprehensive guide to using and administering MySQL effectively and productively. He describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers.

 

The fourth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.0, as well as to add new coverage of features introduced with MySQL 5.1.

 

“One of the best technical books I have read on any subject.”

–Gregory Haley, C Vu, The Association of C & C++ Users

 

“A top-notch user’s guide and reference manual, and in my opinion, the only book you’ll need for the daily operation and maintenance of MySQL databases.”

–Eugene Kim, Web Techniques

 

Introduction 1

 

Part I: General MySQL Use

Chapter 1: Getting Started with MySQL 13

Chapter 2: Using SQL to Manage Data 101

Chapter 3: Data Types 201

Chapter 4: Stored Programs 289

Chapter 5: Query Optimization 303

 

Part II: Using MySQL Programming Interfaces

Chapter 6: Introduction to MySQL Programming 341

Chapter 7: Writing MySQL Programs Using C 359

Chapter 8: Writing MySQL Programs Using Perl DBI 435

Chapter 9: Writing MySQL Programs Using PHP 527

 

Part III: MySQL Administration

Chapter 10: Introduction to MySQL Administration 579

Chapter 11: The MySQL Data Directory 585

Chapter 12: General MySQL Administration 609

Chapter 13: Access Control and Security 699

Chapter 14: Database Maintenance, Backups, and Replication 737

 

Part IV: Appendixes

Appendix A: Obtaining and Installing Software 777

Appendix B: Data Type Reference 797

Appendix C: Operator and Function Reference 813

Appendix D: System, Status, and User Variable Reference 889

Appendix E: SQL Syntax Reference 937

Appendix F: MySQL Program Reference 1037

 

Note: Appendixes G, H, and I are located online and are accessible either by registering this book at informit.com/register or by visiting www.kitebird.com/mysql-book.

Appendix G: C API Reference 1121

Appendix H: Perl DBI API Reference 1177

Appendix I: PHP API Reference 1207

 

Index 1225

 

---

Product Details

• Amazon Sales Rank: #67749 in Books
• Published on: 2008-09-08
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1224 pages

Amazon.com Review
The unexpected pleasure of reading books about databases is that they are often written by authors with highly organized minds. Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database client/server primarily geared for Unix systems but maintained for Windows platforms as well. What isn't "free" about MySQL (the application) is its server's commercial use; all clients and noncommercial server use are free. DuBois's tome isn't free either, but its list price is modest in light of its value and the value of its namesake.

The volume is superbly organized into 12 chapters and 10 appendices and contains a concise table of contents and a comprehensive 50-page index. It is peppered with references to the online HTML documentation that comes with the source and binary distributions (which are available and easy to install in stable rpm and tar releases.)

The first third of MySQL is an excellent instruction tool for database newbies; the second third is a detailed reference for MySQL developers; and the last third consists of clearly annotated appendices, including C, Perl (but not Python), and PHP interfaces.

Perhaps as an indication of the collective will of the developers of MySQL, DuBois does not separate Windows 95/98/NT design or development specifics from its main discussions. Platform-independent design is a goal, not a reality, and users will have to rely on newsgroups and mailing lists for details. Moreover, security issues are addressed in a mere 18 pages, a large part of which is devoted to standard Unix file and network-access permissions. Next to nothing is mentioned about defense against common hacking strategies, the use of secure shell interfaces, or access encryption.

Although it is nearly 800 pages in length, DuBois's book is thankfully not encyclopedic. It is a valuable précis of the MySQL database, and its easy-to-skim look and feel will make it an excellent browse for database experts who want to know what is and is not possible within MySQL, the application. --Peter Leopold

From Library Journal
MySql is a very popular relational database for a number of reasons: it is free for most applications; while not open source it is heavily used by the open source community; and it runs easily on Windows and UNIX. The author's approach is to use two sample databases to explain SQL (structured query) databases with Perl, PHP, and C; administering MySql; and security. This book will be very popular with users who already understand relational databases and are trying to move from Microsoft or Oracle to MySql.
Copyright 2000 Reed Business Information, Inc.

From the Back Cover
In MySQL, Paul DuBois provides you with a comprehensive guide to one of the most popular relational database systems. As an important contributor to the online documentation for MySQL, Paul uses his day-to-day experience answering questions users post on the MySQL mailing list to pinpoint the problems most users and administrators encounter. The principal MySQL developer, Monty Widenius, along with a network of his fellow developers, reviewed the manuscript, providing Paul with the kind of insight no one else could supply. Instead of merely giving you a general overview of MySQL, Paul teaches you how to make the most of its capabilities. Through two sample databases that run throughout the book, he gives you solutions to problems you'll likely face. He helps you integrate MySQL efficiently with third-party tools, such as PHP and Perl, enabling you to generate dynamic Web pages through database queries. He also teaches you to write programs that access MySQL databases.

---

Customer Reviews

The best technical book I've read
I read a lot of computer books both as part of my day job (unix sysadmin) and on the side (wrote 2 computer books). Normally I'm not moved to write nice things about the competition, but this book is truly impressive.

The organization of the chapters is logical, proceeding from introductory to advanced topics in clearly defined stages. The author thankfully resisted the current trend of giving the chapters cutesy names that communicate nothing. The writing is clear and concise. The indexing is superb. The coverage of the subject matter is unbelievably complete, encompassing not only MySQL and general database theory, but also almost every other aspect of database programming.

In the six months I've been working with it I've never been unable to find the answer to a MySQL question in this book. Indeed, the Appendices are so good that I have found answers in here when the books I was reading on PHP and the Perl DBI turned out to be wrong.

MySQL is a very impressive achievement in all respects.

This is *THE* Book
I have purchased many books on SQL. I USUALLY purchase books (I own over 30) from Oreilly, as I did with their MySql/MSQL book which was absolutely NOTHING in comparison to the MySQL book by Other New Riders. I really must say this book is PERFECT. It covers EVERY major topic. It is SUPERBLY written, both novices and experts alike can easily learn, follow, and understand this book. It's an extraordinarly effective tutorial, learing guide, and reference. It gives clear, easy to follow instructions and examples on everything, and anything you need to do in reguard to databases. I give this book my HIGHEST possible recommendation. This book was worth every single penny I paid for it.

Finally, THE book for MySQL
Just got the book two days ago and have not put it down except to read "Building Database Applications on the Web Using PHP3." (another great buy.)

I am new to SQL and this book is something worth buying. It is written for both techies and non-techies, and if you have the desire to learn MySQL, buy this book. It is the most concise and well written book on the language ever.

Make sure you block out a chunk of time, because once you start reading, you will not put this book down. It fills the gap where other books fail. The tutorial gets you up to speed very quickly (VERY) and you will be building databases within the first 1/2 hour of opening the book. I buy an average of 5 or so books a week and I guarantee that most of them will be covered with dust before I put this book down.

If you have the desire to learn on your own and want to learn MySQL...

BUY THE BOOK! Don't wait! Sell something if you have to, get a second job. Whatever it takes, you can not be without this book!