MySQL
From Wikibooks, open books for an open world
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
- 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
- Databases manipulation
- Optimization
- Stored Programs
- 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 sources are released under the GFDL and hence good candidates for inclusion in the wikibook, as well as joint writing efforts:
- MySQL Join Tutorials / Examples (CC-BY 3.0)
- Google Code University's Introduction to Databases and MySQL (CC-BY 2.5)
- The Not-So-Great PHP/MySQL Tutorial (CC-BY-SA 3.0)
- PostgreSQL Documentation: the documentation is released under the mBSD license, which is compatible with the CC-BY-SA and GFDL. It includes generic material about SQL.* #mysql wiki (licensed used to be clear, but not anymore?)
Non-freely-licensed reference documentation
- MySQL has a great used commented documentation on their website - but it's completely non-free.
External links
- GNU support
