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
A printable version of MySQL is available. (edit it)
A PDF version is available. (info)
A LaTeX Version is available.
This book requires that you first read Structured Query Language .
- 100% developed Introduction
- 100% developed MySQL Practical Guide
- 75% developed Databases manipulation
- 75% developed Language
- 75% developed Browsing the databases
- 50% developed Specifying table names
- 50% developed Definitions
- 50% developed User Variables
- 50% developed Alias
- 50% developed Data Types
- 50% developed Table manipulation
- 50% developed Data manipulation
- 50% developed Queries
- 50% developed Using/Dealing with NULL
- 75% developed Operators
- 50% developed Import / export
- 25% developed Functions
- 50% developed Stored Programs
- 25% developed Spatial databases
- 50% developed Exercises
- 50% developed Pivot table or a crosstab report
- 50% developed Table types
- 50% developed MyISAM and InnoDB
- 25% developed Merge Table
- 0% developed MEMORY / HEAP
- 0% developed BDB
- 0% developed BLACKHOLE
- 0% developed Comparison
- With other databases
- With SQL92
- Writing portable, non-MySQL-specific code
- 50% developed Administration
- 25% developed Replication
- 50% developed Optimization
- 0% developed Maintenance and evolution
- 50% developed 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.