MySQL

MySQL is a free, widely used SQL engine. It can be used as a fast database as well as a rock-solid DBMS using a modular engine architecture.

The purpose of this wikibook is to provide a practical knowledge on using the database from two points of view:
 * application developer: learn about SQL basics, phpMyAdmin, query optimization
 * system administrator: learn about installation, security, maintenance, failover, high availability

Best of all, this book is freely available for everybody to use and share, under the GNU Free Documentation License and the Creative Commons Attribution/Share-Alike License.

Contents

 * /Introduction/
 * /MySQL Practical Guide/
 * /Databases manipulation/
 * /Language/
 * Browsing the databases
 * Specifying table names
 * Definitions
 * User Variables
 * Alias
 * Data Types
 * Table manipulation
 * Data manipulation
 * Queries
 * Using/Dealing with NULL
 * Operators
 * Import / export
 * Functions
 * /Stored Programs/
 * Spatial databases
 * Exercises
 * /Pivot table/ or a crosstab report
 * /Table types/
 * MyISAM and InnoDB
 * Merge Table
 * MEMORY / HEAP
 * BDB
 * BLACKHOLE
 * /Comparison/
 * With other databases
 * With SQL92
 * Writing portable, non-MySQL-specific code
 * /Administration/
 * /Replication/
 * /Optimization/
 * /Maintenance and evolution/
 * /APIs/

Appendices

 * /Debugging/
 * /CheatSheet/
 * /Contributors/

Related wikibooks

 * Structured Query Language: about general SQL programming, with lots of exercises.
 * Converting MySQL to PostgreSQL: highlights the differences between the two database servers

Freely-licensed documentation and samples
The following source is released under the GFDL and hence a good candidate for inclusion in the wikibook, as well as joint writing efforts:


 * (CC-BY-SA 3.0)

Non-freely-licensed reference documentation

 * MySQL has a great used commented documentation on their website - and it's completely free.