MySQL (4th Edition) and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Start reading MySQL (4th Edition) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL (4th Edition) [Paperback]

Paul DuBois

List Price: CDN$ 54.99
Price: CDN$ 34.64 & FREE Shipping. Details
You Save: CDN$ 20.35 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it delivered Friday, October 24? Choose One-Day Shipping at checkout.


Amazon Price New from Used from
Kindle Edition CDN $28.66  
Paperback CDN $34.64  
There is a newer edition of this item:
MySQL (5th Edition) MySQL (5th Edition)
CDN$ 32.59
In Stock.
Join Amazon Student in Canada

Book Description

Aug. 29 2008 0672329387 978-0672329388 4

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 or by visiting

Appendix G: C API Reference 1121

Appendix H: Perl DBI API Reference 1177

Appendix I: PHP API Reference 1207


Index 1225


Customers Who Bought This Item Also Bought

Product Details

Product Description

About the Author

Paul DuBois is a writer, database administrator, and leader in the open source and MySQL communities. He has contributed to the online documentation for MySQL and is the author of MySQL and Perl for the Web (New Riders), MySQL Cookbook, Using csh

and tcsh, and Software Portability with imake (O’Reilly). He is currently a technical writer with the MySQL documentation team at Sun Microsystems.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.2 out of 5 stars  15 reviews
10 of 10 people found the following review helpful
4.0 out of 5 stars This is a reference book, by the same person who writes the online documentation. Jan. 6 2011
By Gregory A. Gum - Published on
Format:Paperback|Verified Purchase
While this book is a comprehensive, I found it to be more of a reference book than otherwise. It covers pretty much the same material as what is found in the online docs. Which isn't surprising as the book author is an employee of MySQL and writes the online documentation. The book is valuable as a reference, but it weighs in at 1200 pages which is more than I am going to sit down and read as a narrative.

The first chapter is a tutorial, but after that, it's all reference material. If that is what you are looking for, great. But if your looking for beginner/intermediate material, this is not it. The book does not cover MYSQL Workbench at all which is what the newcomer to MySQL normally uses to get started. Nobody wants to learn MySQL just from a command prompt, but this is the approach the book takes.

17 of 22 people found the following review helpful
1.0 out of 5 stars No usable index! March 30 2011
By John H. Hardin - Published on
Format:Kindle Edition|Verified Purchase
This review is specifically for the Kindle edition.

After receiving the download of this ebook, I was astounded to find that the index was just a list of terms with no link to the actual location in the book where the topic is discussed. This is not true of all Kindle books, because MySQL High Availability from O'Reilly, which I also purchased on the Kindle recently, does have a working index where each item is a hot link into the book. The pagination of a Kindle book varies by the font selected, so I can understand removing page numbers from the index. But then you have to make the items links, like you have in the Table of Contents. I would caution anyone interested in the Kindle version of this book to consider whether they can use a 1200+ page book of technical information without an index. I have to wonder if this no-index policy is true of the other books from this publisher. I don't know how to find out without first buying the book for the Kindle.
4 of 4 people found the following review helpful
5.0 out of 5 stars Excellent Book Feb. 4 2010
By Eric - Published on
Format:Paperback|Verified Purchase
This book has been super useful. I was new to development with MySQL and among the 3 or 4 MySQL books I got, this is the go-to book I use. It's very thorough, explains things clearly, and has lots of concise examples to show statements in use. Highly recommend it.
3 of 3 people found the following review helpful
4.0 out of 5 stars Essential for MySQL work Oct. 11 2008
By Paul Whipp - Published on
Format:Paperback|Verified Purchase
This is an excellent text that should be used as an example by other text book authors. Its detail is moderated by its excellent index and contents which has resulted in my using it almost every day since I bought it.

Why not five stars? I could use a little more detail on underlying reasons and how-tos and a little better highlighting in the text to bring out examples etc.
3 of 3 people found the following review helpful
5.0 out of 5 stars Great resource Nov. 7 2009
By Roy C. Berry - Published on
Format:Paperback|Verified Purchase
Great book, describes from Beginner to Moderate-advanced topics. This could be considered "the" manual for MySql.

Look for similar items by category