MySQL Phrasebook

The MySQL Phrasebook is a pocket guide that is jam-packed with useful and essential code "phrases" for the MySQL developer's everyday use. Packed with practical solutions for tasks that the MySQL developer must accomplish every day, it fills the need for a short, functional, to-the-point reference for MySQL. This is the guide to consult when you need an immediate, applicable solution to frequent tasks and code that is flexible and adaptable to your needs. Your time won't be wasted on more tutorials — it simply puts essential "phrases" at your fingertips that you can take with you everywhere.

Table of Contents

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