Where to find MySQL information

Quicklinks:

Note: This page is an organized one-stop source to information about MySQL and it is assumed that you have already found MySQL at http://www.mysql.com. The main MySQL

mirror

is located at http://mirrors.sunsite.dk/mysql/.

Organization of the MySQL Manual
#	5.1	Section	#	5.0	Section	#	3.23, 4.0, 4.1	Section
		Preface			Preface			Preface
1		General Information	1		General Information	1		General Information
2		Installing MySQL	2		Installing MySQL	2		Installing MySQL
3		Tutorial	3		Tutorial	3		Tutorial
4		Using MySQL Programs	4		Using MySQL Programs	4		Using MySQL Programs
5		Database Administration	5		Database Administration	5		Database Administration
6		Replication in MySQL	6		Replication in MySQL	6		Replication in MySQL
7		Optimization	7		Optimization	7		Optimization
8		Client and Utility Programs	8		Client and Utility Programs	8		Client and Utility Programs
9		Language Structure	9		Language Structure	9		Language Structure
10		Character Set Support	10		Character Set Support	10		Character Set Support
11		Data Types	11		Data Types	11		Data Types
12		Functions and Operators	12		Functions and Operators	12		Functions and Operators
13		SQL Statement Syntax	13		SQL Statement Syntax	13		SQL Statement Syntax
#	5.1	Section	#	5.0	Section	#	3.23, 4.0, 4.1	Section
14		Pluggable Storage Engine Architecture	14		Storage Engines and Table Types	14		Storage Engines and Table Types
15		Storage Engines and Table Types	15		MySQL Cluster	15		The InnoDB Storage Engine
16		Writing a Custom Storage Engine	16		Spatial Extensions in MySQL	16		MySQL Cluster
17		MySQL Cluster	17		Stored Procedures and Functions	17		Spatial Extensions in MySQL
18		Partitioning	18		Triggers	18		APIs and Libraries
19		Spatial Extensions in Mysql	19		Views	19		Connectors
20		Stored Procedures and Functions	20		The INFORMATION_SCHEMA Database	20		Extending MySQL
21		Triggers	21		Precision Math
22		Views	22		APIs and Libraries
23		The INFORMATION_SCHEMA Database	23		Connectors
24		Precision Math	24		Extending MySQL
25		APIs and Libraries
26		Connectors
27		Extending MySQL
#	5.1	Section	#	5.0	Section	#	3.23, 4.0, 4.1	Section
A		Problems and Common Errors	A		Problems and Common Errors	A		Problems and Common Errors
B		Error Codes and Messages	B		Error Codes and Messages	B		Error Codes and Messages
C		Credits	C		Credits	C		Credits
D		MySQL Change History	D		MySQL Change History	D		MySQL Change History
E		Porting to Other Systems	E		Porting to Other Systems	E		Porting to Other Systems
F		Environment Variables	F		Environment Variables	F		Environment Variables
G		MySQL Regular Expressions	G		MySQL Regular Expressions	G		MySQL Regular Expressions
H		Limits in MySQL	H		Limits in MySQL	H		Limits in MySQL
I		Feature Restrictions	I		Feature Restrictions	I		Feature Restrictions
J		GNU General Public License	J		GNU General Public License	J		GNU General Public License
K		MySQL FLOSS License Exception	K		MySQL FLOSS License Exception	K		MySQL FLOSS License Exception
	5.1	Index		5.0	Index		3.23, 4.0, 4.1	Index
Quickly find functions like BETWEEN(), IN(), SUBSTRING(), CONCAT()
	5.1	Full Table of Contents		5.0	Full Table of Contents		3.23, 4.0, 4.1	Full Table of Contents

Common Searches
Column Types and Storage Requirements CREATE TABLE Syntax DROP TABLE Syntax and IF EXISTS ALTER TABLE Syntax includes resetting the AUTO_INCREMENT number Getting the unique ID for the last inserted row INSERT Syntax and "ON DUPLICATE" for updating existing records UPDATE Syntax DELETE Syntax REPLACE Syntax SELECT Syntax JOIN Syntax see normalization Tutorials for more information Subqueries aka subselects, try JOIN first GROUP BY (Aggregate) Functions - count(), min(), max(), sum(), avg() Reserved Words String Comparison Functions and escape characters Pattern matching regular expressions and wildcards Date and time functions INTERVAL(), DATE_FORMAT(), MONTH(), etc. Control flow functions IF() and IFNULL() Miscellaneous Functions to store IP addresses, use INET_ATON() and INET_NTOA()	Server and Startup Scripts The MySQL Access Privilege System, see also GRANT and REVOKE Importing SQL Using MySQL in batch mode from the command line Executing SQL Statements from a Text File from the command line SOURCE or \. from the MySQL command line Importing data - CSV, etc. mysqlimport from the command line LOAD DATA INFILE from the MySQL command line Exporting data - SQL, CSV, etc. mysqldump from the command line SELECT INTO OUTFILE or DUMPFILE, from the MySQL command line Backup mysqlhotcopy and mysqldump Optimizing Database Structure Optimizing queries EXPLAIN syntax Indexes Benchmarks test your success MySQL FAQ more on new and upcoming features
MySQL Manual Search
Search the MySQL manual: the whole site Manual 3.23, 4.0, 4.1 Manual 5.0 Manual 5.1
MySQL Mailing Lists
Search mailing lists for: within all lists MySQL Announcements MySQL General Discussion MySQL Cluster Discussion MySQL Replication Discussion MySQL on Win32 MySQL Internals MySQL Commits MySQL GUI Tools MySQL and Java MySQL ODBC MySQL and Perl MySQL and .NET MySQL++ MaxDB MySQL Documentation Database Benchmarks MySQL Certification Announcements MySQL Packagers MySQL German Discussion MySQL Spanish Discussion MySQL Japanese Discussion MySQL Bugs Eventum General Discussion Eventum Development MySQL Community MySQL Users Conference Brisbane MySQL Users Group Houston MySQL Users Group Stuttgart MySQL Users Group matching any of the words all of the words a boolean search since the beginning 7 days ago 30 days ago 60 days ago 90 days ago 180 days ago 365 days ago
PHP
For more information on using PHP with mysql, see the MySQL section of the PHP documentation on PHP.net.
MySQL Forums
MySQL Forums
MySQL Bugs
Bugs

Internet Relay Chat (IRC)

Or ask your question on IRC... NOTE: If you are new to IRC (Internet Relay Chat), you are advised to read the docs first.

Then join us on EFnet, channel #mysql or #phpmysql for PHP/MySQL questions.

Version	Milestones
5.1
5.0	Views; Stored Procedures
4.1	Subqueries, INSERT ... ON DUPLICATE KEY UPDATE; GROUP_CONCAT()
4.0	UNION; Multi-table DELETE; query caching; full-text search
3.23	MyISAM, InnoDB and BDB table types; replication (3.23.15)

Tutorials

Need to learn more? For SQL and MySQL tutorials, try one of these links:

• Introduction to Relational Databases WDVL
• http://www.sqlcourse.com/ Interactive SQL Tutorial with SQL interpreter & live database
• http://www.sqlcourse2.com/
• Database Normalization And Design Techniques PHPBuilder
• Database Normalization WDVL
• Database tutorials at WDVL
• MySQL at Developer Shed DevShed
• Transactions in MySQL Webmonkey

Books

Looking for a book about MySQL? Check out this link:
MySQL (OTHER NEW RIDERS) by Paul DuBois, Michael Widenius