Addison-Wesley | ISBN-13: 9780672329388 | English | Sep-2008 | PDF | Size: 3.95 MB | 1326 Pages | RAR Compressed | No Password


With over 11 million installations, MySQL is the most widely used open source database management system worldwide. Many of the world's largest and fastest-growing organizations use MySQL to power high-volume Web sites, business-critical systems and packaged software -- including industry leaders such as Yahoo, Google, The Associated Press, Suzuki, and NASA. MySQL 5.1 is a significant new version of the database that further brings MySQL up to the level of an enterprise-class database system. In MySQL, Paul DuBois provides a comprehensive guide to using MySQL effectively and productively. He describes everything from the basics, to using MySQL to generate dynamic Web pages, to administering MySQL servers. The fourth edition of this bestseller has been reviewed by top developers in the MySQL community and incorporates feedback from readers and top MySQL developers. With detailed coverage of new features and improvements in MySQL 5.1, this is the most comprehensive and thorough edition to date. This new edition includes extended coverage of stored programs -- stored procedures, functions and triggers; coverage of a new type of stored program -- events; a completely new chapter on "Stored Programs"; completely rewritten PHP chapter and appendix.


Table Of Contents


Introduction to MySQL and SQL.

Working with Data in MySQL.

MySQL SQL Syntax and Use.

Query Optimization.

Using MySQL Programming Interfaces.

Introduction to MySQL Programming.


The Perl DBI API.


Introduction to MySQL Administration.

The MySQL Data Directory.

General MySQL Administration.


Database Maintenance and Repair.

Obtaining and Installing Software.

Column Type Reference.

Operator and Function Reference.

SQL Syntax Reference.

MySQL Program Reference.

C API Reference.

Perl DBI API Reference.

PHP API Reference.

Useful Third-Party Tools.

Internet Service Providers.