MySQL

Language

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

A printable version of MySQL is available. (edit it)

Category:Books with print version#MySQL

A PDF version Category:Books with PDF version is available. (info)

A LaTeX Version is available.

Wikipedia has related information at MySQL

This book requires that you first read Structured Query Language.

Introduction
MySQL Practical Guide
Databases manipulation
Language
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

Resources

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:

"MySQL vs MongoDB". (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.

External links

Category:Subject:SQL/all books Category:Subject:Computer programming languages/all books Category:Subject:Computer programming/all books Category:Subject:Computer science/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Subject:Database management systems/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Subject:Database management systems#MySQL Category:Subject:Database management systems/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Subject:Open source software#MySQL Category:Subject:Open source software/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Book:MySQL#%20 Category:Book:Wikibooks Stacks/Books#MySQL Category:Shelf:SQL Category:Shelf:SQL/all books Category:Shelf:Computer programming/all books#Computer%20programming Category:Shelf:Computer programming languages/all books#Computer%20programming%20languages Category:Shelf:Computer science/all books#Computer%20science Category:Shelf:Computer software/all books#Computer%20software Category:Department:Computing/all books#Computing Category:Shelf:Database management systems/all books#Database%20management%20systems Category:Shelf:Database management systems Category:Shelf:Database management systems/all books Category:Shelf:Computer software/all books#Computer%20software Category:Department:Computing/all books#Computing Category:Shelf:Open source software Category:Shelf:Open source software/all books Category:Shelf:Computer software/all books#Computer%20software Category:Department:Computing/all books#Computing Category:Alphabetical/M Category:Books nearing completion Category:Books by completion status/all books

Category:Alphabetical/M Category:Book:MySQL Category:Book:Wikibooks Stacks/Books Category:Books by completion status/all books Category:Books nearing completion Category:Books with PDF version Category:Books with print version Category:Department:Computing/all books Category:Shelf:Computer programming/all books Category:Shelf:Computer programming languages/all books Category:Shelf:Computer science/all books Category:Shelf:Computer software/all books Category:Shelf:Database management systems Category:Shelf:Database management systems/all books Category:Shelf:Open source software Category:Shelf:Open source software/all books Category:Shelf:SQL Category:Shelf:SQL/all books Category:Subject:Books by subject/all books Category:Subject:Computer programming/all books Category:Subject:Computer programming languages/all books Category:Subject:Computer science/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Database management systems Category:Subject:Database management systems/all books Category:Subject:Open source software Category:Subject:Open source software/all books Category:Subject:SQL Category:Subject:SQL/all books