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
- 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.