Abstract
This is the MySQL™ Reference Manual. It documents MySQL 5.7 through 5.7.2.
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-05-12 (revision: 35152)
Table of Contents [+/-]
noinstall Zip ArchiveAUTO_INCREMENTInnoDB Tables [+/-]InnoDB Tables and Indexes [+/-]MyISAM to
InnoDBAUTO_INCREMENT Handling in InnoDBInnoDB and FOREIGN KEY ConstraintsInnoDB Compressed TablesInnoDB File-Format ManagementInnoDB Stores Variable-Length ColumnsInnoDB Tables [+/-]InnoDB Tables [+/-]InnoDB TablesInnoDB Transaction ManagementInnoDB LoggingInnoDB TablesInnoDB QueriesInnoDB DDL OperationsInnoDB Disk I/OInnoDB Configuration VariablesInnoDB for Systems with Many TablesMyISAM Tables [+/-]MEMORY TablesIS NULL OptimizationLEFT JOIN and RIGHT JOIN
OptimizationORDER BY OptimizationGROUP BY OptimizationDISTINCT OptimizationINTEGER,
INT, SMALLINT,
TINYINT, MEDIUMINT,
BIGINTDECIMAL,
NUMERICFLOAT,
DOUBLEBITDATE, DATETIME, and
TIMESTAMP TypesTIME TypeYEAR TypeYEAR(2) Limitations and Migrating to
YEAR(4)TIMESTAMP and
DATETIMEGROUP BY Clauses [+/-]ALTER 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 Engine [+/-]InnoDB TablesInnoDBInnoDB Concepts and ArchitectureInnoDB Performance Tuning and TroubleshootingInnoDB Features for Flexibility, Ease of Use and
ReliabilityInnoDB Startup Options and System VariablesInnoDB TablesMyISAM Storage Engine [+/-]MEMORY Storage EngineCSV Storage Engine [+/-]ARCHIVE Storage EngineBLACKHOLE Storage EngineMERGE Storage Engine [+/-]FEDERATED Storage Engine [+/-]EXAMPLE 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 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
InnoDB [+/-]INFORMATION_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_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
© 2013, Oracle Corporation and/or its affiliates