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 MySQL MySQL Structured Query Language 100% /Introduction/ 100% /MySQL Practical Guide/ 75% /Databases manipulation/ 75% /Language/ 75% Browsing the databases 50% Specifying table names 50% Definitions 50% User Variables 50% Alias 50% Data Types 50% Table manipulation 50% Data manipulation 50% Queries 50% Using/Dealing with NULL 75% Operators 50% Import / export 25% Functions 50% /Stored Programs/ 25% Spatial databases 50% Exercises 50% /Pivot table/ or a crosstab report 50% /Table types/ 50% MyISAM and InnoDB 25% Merge Table 00% MEMORY / HEAP 00% BDB 00% BLACKHOLE 00% /Comparison/ With other databases With SQL92 Writing portable, non-MySQL-specific code 50% /Administration/ 25% /Replication/ 50% /Optimization/ 00% /Maintenance and evolution/ 50% /APIs/ Appendices 25% /Debugging/ 75% /CheatSheet/ /Contributors/ 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: http://blog.qburst.com/2014/09/mysql-vs-mongodb/ 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 http://www.sqlstyle.guide/ Official audio book MySQL copyrighted tutorial on webdevelopersnotes.com SQL Database management systems Open source software M 75% __NOTOC__ __NOEDITSECTION__