• ISBN13:


  • ISBN10:


  • Edition: 5th
  • Format: Paperback
  • Copyright: 2013-04-02
  • Publisher: Addison-Wesley Professional

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
  • We Buy This Book Back!
    In-Store Credit: $3.15
    Check/Direct Deposit: $3.00
List Price: $54.99 Save up to $13.75
  • Rent Book $41.24
    Add to Cart Free Shipping


Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


This is the definitive, best-selling guide to using, programming, and administering MySQL 5.5, the newest version of the world's #1 open source database. Authored by Paul DuBois, the open source community leader who now leads MySQL's own English language documentation team, this guide is perfect for MySQL users at all levels of experience, in roles ranging from web developer to database administrator. Fully updated to reflect the final stable version of MySQL 5.5, MySQL, Fifth Editionhas been meticulously revised and updated to cover important new features that extend MySQL's power and make it even more valuable in large-scale enterprise environments. Throughout, DuBois focuses on the productive and effective use of MySQL in real-world environments. DuBois covers all this: efficiently capturing information in a MySQL database, and formulating queries to retrieve it; using MySQL with PHP or Perl to generate dynamic web pages; writing programs that access MySQL databases; administering MySQL servers; controlling database access and enforcing security; maintaining, backing up, and replicating MySQL databases, and much more. This Fifth Edition incorporates extensive feedback from both readers and top developers throughout the MySQL global community, and also includes significantly expanded coverage of stored procedures, functions, triggers, and events.

Author Biography

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 Oracle Corporation.

Table of Contents

Part I. General MySQL Use
1. Getting Started with MySQL and SQL
2. MySQL SQL Syntax and Use
3. Working with Data in MySQL
4. Stored Programs
5. Query Optimization

Part II. Using MySQL Programming Interfaces
6. Introduction to MySQL Programming
7. Writing MySQL Programs Using C
8. Writing MySQL Programs Using Perl DBI
9. Writing MySQL Programs Using PHP

Part III. MySQL Administration
10. Introduction to MySQL Administration
11. The MySQL Data Directory
12. General MySQL Administration
13. MySQL and Security
14. Database Backups, Maintenance, and Repair

A. Obtaining and Installing Software
B. Data Type Reference
C. Operator and Function Reference
D. System, Status, and User Variable Reference
E. SQL Syntax Reference
F. MySQL Program Reference

Rewards Program

Write a Review