Abstract
This is the MySQL™ Reference Manual. It documents MySQL 5.7 through 5.7.3.
MySQL Cluster is currently not supported in MySQL 5.7. For information about MySQL Cluster, please see MySQL Cluster NDB 7.2.
MySQL 5.7 features. This manual describes features that are not included in every edition of MySQL 5.7; such features may not be included in the edition of MySQL 5.7 licensed to you. If you have any questions about the features included in your edition of MySQL 5.7, refer to your MySQL 5.7 license agreement or contact your Oracle sales representative.
For release notes detailing the changes in each release, see the MySQL 5.7 Release Notes.
For legal information, see the Legal Notices.
Document generated on: 2013-09-10 (revision: 36181)
Table of Contents
noinstall Zip ArchiveAUTO_INCREMENTInnoDB TablesInnoDB Tables and IndexesMyISAM to
InnoDBAUTO_INCREMENT Handling in InnoDBInnoDB and FOREIGN KEY ConstraintsInnoDB Compressed TablesInnoDB File-Format ManagementInnoDB Stores Variable-Length ColumnsInnoDB TablesInnoDB TablesInnoDB TablesInnoDB TablesInnoDB Transaction ManagementInnoDB LoggingInnoDB TablesInnoDB QueriesInnoDB DDL OperationsInnoDB Disk I/OInnoDB Configuration VariablesInnoDB for Systems with Many TablesMyISAM TablesMEMORY TablesINTEGER,
INT, SMALLINT,
TINYINT, MEDIUMINT,
BIGINTDECIMAL,
NUMERICFLOAT,
DOUBLEBITDATE, DATETIME, and
TIMESTAMP TypesTIME TypeYEAR TypeYEAR(2) Limitations and Migrating to
YEAR(4)TIMESTAMP and
DATETIMEGROUP BY ClausesALTER DATABASE SyntaxALTER EVENT SyntaxALTER FUNCTION SyntaxALTER PROCEDURE SyntaxALTER SERVER SyntaxALTER TABLE SyntaxALTER VIEW SyntaxCREATE DATABASE SyntaxCREATE EVENT SyntaxCREATE FUNCTION SyntaxCREATE INDEX SyntaxCREATE PROCEDURE and
CREATE FUNCTION SyntaxCREATE SERVER SyntaxCREATE TABLE SyntaxCREATE TRIGGER SyntaxCREATE VIEW SyntaxDROP DATABASE SyntaxDROP EVENT SyntaxDROP FUNCTION SyntaxDROP INDEX SyntaxDROP PROCEDURE and
DROP FUNCTION SyntaxDROP SERVER SyntaxDROP TABLE SyntaxDROP TRIGGER SyntaxDROP VIEW SyntaxRENAME TABLE SyntaxTRUNCATE TABLE SyntaxSTART TRANSACTION,
COMMIT, and
ROLLBACK SyntaxSAVEPOINT,
ROLLBACK TO
SAVEPOINT, and
RELEASE
SAVEPOINT SyntaxLOCK TABLES and
UNLOCK
TABLES SyntaxSET TRANSACTION SyntaxInnoDB Storage EngineInnoDB TablesInnoDBInnoDB Concepts and ArchitectureInnoDB Performance Tuning and TroubleshootingInnoDB Features for Flexibility, Ease of Use and
ReliabilityInnoDB Startup Options and System VariablesInnoDB TablesMyISAM Storage EngineMEMORY Storage EngineCSV Storage EngineARCHIVE Storage EngineBLACKHOLE Storage EngineMERGE Storage EngineFEDERATED Storage EngineEXAMPLE Storage EngineINFORMATION_SCHEMA TablesINFORMATION_SCHEMA CHARACTER_SETS TableINFORMATION_SCHEMA COLLATIONS TableINFORMATION_SCHEMA
COLLATION_CHARACTER_SET_APPLICABILITY TableINFORMATION_SCHEMA COLUMNS TableINFORMATION_SCHEMA COLUMN_PRIVILEGES TableINFORMATION_SCHEMA ENGINES TableINFORMATION_SCHEMA EVENTS TableINFORMATION_SCHEMA FILES TableINFORMATION_SCHEMA GLOBAL_STATUS and
SESSION_STATUS
TablesINFORMATION_SCHEMA GLOBAL_VARIABLES and
SESSION_VARIABLES
TablesINFORMATION_SCHEMA KEY_COLUMN_USAGE TableINFORMATION_SCHEMA OPTIMIZER_TRACE TableINFORMATION_SCHEMA PARAMETERS TableINFORMATION_SCHEMA PARTITIONS TableINFORMATION_SCHEMA PLUGINS TableINFORMATION_SCHEMA PROCESSLIST TableINFORMATION_SCHEMA PROFILING TableINFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS TableINFORMATION_SCHEMA ROUTINES TableINFORMATION_SCHEMA SCHEMATA TableINFORMATION_SCHEMA SCHEMA_PRIVILEGES TableINFORMATION_SCHEMA STATISTICS TableINFORMATION_SCHEMA TABLES TableINFORMATION_SCHEMA TABLESPACES TableINFORMATION_SCHEMA TABLE_CONSTRAINTS TableINFORMATION_SCHEMA TABLE_PRIVILEGES TableINFORMATION_SCHEMA TRIGGERS TableINFORMATION_SCHEMA USER_PRIVILEGES TableINFORMATION_SCHEMA VIEWS TableINFORMATION_SCHEMA Tables for
InnoDBINFORMATION_SCHEMA INNODB_CMP and
INNODB_CMP_RESET TablesINFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET TablesINFORMATION_SCHEMA INNODB_CMPMEM and
INNODB_CMPMEM_RESET TablesINFORMATION_SCHEMA INNODB_TRX TableINFORMATION_SCHEMA INNODB_LOCKS TableINFORMATION_SCHEMA INNODB_LOCK_WAITS TableINFORMATION_SCHEMA INNODB_SYS_TABLES TableINFORMATION_SCHEMA INNODB_SYS_INDEXES TableINFORMATION_SCHEMA INNODB_SYS_COLUMNS TableINFORMATION_SCHEMA INNODB_SYS_FIELDS TableINFORMATION_SCHEMA INNODB_SYS_FOREIGN TableINFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS TableINFORMATION_SCHEMA INNODB_SYS_TABLESTATS ViewINFORMATION_SCHEMA INNODB_SYS_DATAFILES TableINFORMATION_SCHEMA INNODB_SYS_TABLESPACES TableINFORMATION_SCHEMA INNODB_BUFFER_PAGE TableINFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU TableINFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS TableINFORMATION_SCHEMA INNODB_METRICS TableINFORMATION_SCHEMA INNODB_FT_CONFIG TableINFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD
TableINFORMATION_SCHEMA INNODB_FT_INDEX_TABLE TableINFORMATION_SCHEMA INNODB_FT_INDEX_CACHE TableINFORMATION_SCHEMA INNODB_FT_DELETED TableINFORMATION_SCHEMA INNODB_FT_BEING_DELETED TableINFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO TableSHOW StatementsCALL
StatementsMysql)Mysqli)MySQL (PDO))Mysqlnd)mysqlnd_ms)mysqlnd_qc)mysqlnd_uh)mysqlnd_mux)mysqlnd_memcache)mysql and mysqli in
PHPdtoa.c Licenselibedit) LicenseFindGTest.cmake Licensegetarg Licenselib_sql.cc Licenselibevent Licenselibintl LicenseLPeg Library LicenseLuaFileSystem Library Licensememcached Licensemkpasswd.pl Licensezlib LicenseINFORMATION_SCHEMAINFORMATION_SCHEMA Index