Abstract
This is the MySQL™ Reference Manual. It documents MySQL 5.0 through 5.0.96.
End of Product LifecycleActive development for MySQL Database Server version 5.0 has ended. Oracle offers various support offerings which may be of interest. For details and more information, see the MySQL section of the Lifetime Support Policy for Oracle Technology Products (http://www.oracle.com/us/support/lifetime-support/index.html). Please consider upgrading to a recent version.
MySQL 5.0 features. This manual describes features that are not included in every edition of MySQL 5.0 and such features may not be included in the edition of MySQL 5.0 licensed to you. If you have any questions about the features included in your edition of MySQL 5.0, refer to your MySQL 5.0 license agreement or contact your Oracle representative.
For release notes detailing the changes in each release, see the MySQL 5.0 Release Notes.
For legal information, see the Legal Notices.
Document generated on: 2013-05-17 (revision: 35197)
Table of Contents [+/-]
GnuPG [+/-]noinstall Zip ArchiveAUTO_INCREMENTGROUP BY Clauses [+/-]ALTER DATABASE SyntaxALTER FUNCTION SyntaxALTER PROCEDURE SyntaxALTER TABLE SyntaxALTER VIEW SyntaxCREATE DATABASE SyntaxCREATE FUNCTION SyntaxCREATE INDEX SyntaxCREATE PROCEDURE and
CREATE FUNCTION SyntaxCREATE TABLE SyntaxCREATE TRIGGER SyntaxCREATE VIEW SyntaxDROP DATABASE SyntaxDROP FUNCTION SyntaxDROP INDEX SyntaxDROP PROCEDURE and
DROP FUNCTION SyntaxDROP TABLE SyntaxDROP TRIGGER SyntaxDROP VIEW SyntaxRENAME TABLE SyntaxTRUNCATE TABLE SyntaxSTART TRANSACTION,
COMMIT, and
ROLLBACK SyntaxSAVEPOINT,
ROLLBACK TO
SAVEPOINT, and
RELEASE
SAVEPOINT, and SyntaxLOCK TABLES and
UNLOCK
TABLES SyntaxSET TRANSACTION SyntaxMyISAM Storage Engine [+/-]InnoDB Storage Engine [+/-]InnoDB ConfigurationInnoDB Startup Options and System VariablesInnoDB TablesInnoDB Data and Log
FilesInnoDB
DatabaseInnoDB Database to Another MachineInnoDB Transaction Model and LockingInnoDB Multi-VersioningInnoDB Table and Index StructuresInnoDB Disk I/O and File Space ManagementInnoDB Error HandlingInnoDB Performance Tuning and TroubleshootingInnoDB TablesMERGE Storage Engine [+/-]MEMORY (HEAP) Storage EngineBDB (BerkeleyDB) Storage
Engine [+/-]EXAMPLE Storage EngineFEDERATED Storage Engine [+/-]ARCHIVE Storage EngineCSV Storage EngineBLACKHOLE Storage EngineINFORMATION_SCHEMA Tables [+/-]INFORMATION_SCHEMA CHARACTER_SETS TableINFORMATION_SCHEMA COLLATIONS TableINFORMATION_SCHEMA
COLLATION_CHARACTER_SET_APPLICABILITY TableINFORMATION_SCHEMA COLUMNS TableINFORMATION_SCHEMA COLUMN_PRIVILEGES TableINFORMATION_SCHEMA KEY_COLUMN_USAGE TableINFORMATION_SCHEMA PROFILING TableINFORMATION_SCHEMA ROUTINES TableINFORMATION_SCHEMA SCHEMATA TableINFORMATION_SCHEMA SCHEMA_PRIVILEGES TableINFORMATION_SCHEMA STATISTICS TableINFORMATION_SCHEMA TABLES TableINFORMATION_SCHEMA TABLE_CONSTRAINTS TableINFORMATION_SCHEMA TABLE_PRIVILEGES TableINFORMATION_SCHEMA TRIGGERS TableINFORMATION_SCHEMA USER_PRIVILEGES TableINFORMATION_SCHEMA VIEWS TableSHOW StatementsCALL
StatementsMysql)Mysqli)MySQL (PDO))Mysqlnd)mysqlnd_ms)mysqlnd_qc)mysqlnd_uh)mysqlnd_mux)mysqlnd_memcache)mysql and mysqli in
PHPdtoa.c Licenselibedit) Licenselib_sql.cc Licenselibevent Licenselibintl LicenseLPeg Library LicenseLuaFileSystem Library Licensezlib LicenseINFORMATION_SCHEMAINFORMATION_SCHEMA Index