MySQL

by Dubois, Paul

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

Summary

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

Appendixes
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