MySQL Phrasebook

Zak Greant is a technical evangelist, author and programmer whose deep and constant love of Free Software and Open Source has made him an admired and sought-after speaker, developer and advocate. Zak currently works at eZ Systems where he helps businesses and Free/Open projects create and execute plans for their strategic, marketing, human resource, product, service, and information technology management activities.   Chris Newman is a consultant programmer specializing in database development with an Internet twist.  He has extensive commercial experience of using PHP to integrate various database systems and has produced a wide range of applications for an international client base.  He runs Lightwood Consultancy Ltd, the company he founded in 1999 to further his interest in online database development.  Newman has served as a technical editor on several books from Sams, including PHP and MySQL Web Development, Teach Yourself PHP, MySQL & Apache All in One, and Red Hat Fedora Unleashed.  He is a frequent contributor to PHPBuilder.com and also wrote SQLite and Sams Teach Yourself PHP in 10 Minutes.

Contents at a Glance

1    Maps of MySQL    5

2    Creating and Managing Databases, Tables, and Indexes    11

3    Storing Data    29

4    Retrieving Data: Simple Queries    43

5    Manipulating Data    55

6    User Management and Security    65

7    The mysql Command-line Client    81

8    MySQL APIs    91

9    Advanced Queries    109    

10    Troubleshooting and Emergencies    121

A    A Brief MySQL Tutorial    135