MySQL Documentation - Alphabetical List

This is an somewhat alphabetical listing of my MySQL documentation, grouped first by type of command (i.e., statements, clauses, functions). This is provided as a quick way to get to the documentation page when you know which SQL statement or function you need information on.

MySQL SQL Statements

• BEGIN
• COMMIT
• HELP
• RELEASE SAVEPOINT
• ROLLBACK
• ROLLBACK TO SAVEPOINT
• SAVEPOINT
• SET TRANSACTION
• START TRANSACTION
• USE
• XA
• LOAD INDEX INTO CACHE
• CHANGE MASTER TO
• LOAD DATA FROM MASTER
• LOAD TABLE...FROM MASTER
• MASTER_POS_WAIT( )
• PURGE MASTER LOGS
• RESET MASTER
• RESET SLAVE
• SET GLOBAL SQL_SLAVE_SKIP_COUNTER
• SET SQL_LOG_BIN
• SHOW BINARY LOGS
• SHOW BINLOG EVENTS
• SHOW MASTER LOGS
• SHOW MASTER STATUS
• SHOW SLAVE HOSTS
• SHOW SLAVE STATUS
• START SLAVE
• STOP SLAVE
• GRANT
• GRANT - Connection Restrictions Types
• GRANT - Time and Number of Connection Limits
• GRANT - Privileges in GRANT and REVOKE
• CREATE DATABASE
• INSERT
• INSERT - Single-row insertion with SET clause
• INSERT - Multiple-row insertions
• INSERT - Inserting rows based on a SELECT
• Single Field Subqueries
• Multiple Fields Subqueries
• Results Set Subqueries
• REVOKE
• ALTER DATABASE
• SELECT
• SELECT Statement Keywords
• SELECT - Exporting results
• SELECT - Grouping results
• SELECT - Having results
• SELECT - Ordering results
• SELECT - Limiting results
• SELECT - Other Clauses & Options
• CREATE USER
• RENAME DATABASE
• REPLACE
• RENAME USER
• DROP DATABASE
• UPDATE
• UPDATE - Single Table
• UPDATE - Multiple Tables
• DROP USER
• SHOW DATABASES
• DELETE
• SET
• BACKUP TABLE
• CACHE INDEX
• CHECKSUM TABLE
• KILL
• RESET
• RESTORE TABLE
• SET
• SET PASSWORD
• SHOW CREATE DATABASE
• SHOW GRANTS
• CREATE SCHEMA
• SHOW PRIVILEGES
• ALTER SCHEMA
• RESET
• CREATE TABLE
• CREATE TABLE - Column flags
• CREATE TABLE - Index and key definitions
• CREATE TABLE - References
• CREATE TABLE - Sub-Partition definitions
• CREATE TABLE - Based on an existing table
• CREATE TABLE - Partition definitions
• CREATE TABLE - Partitioning
• CREATE TABLE - Table options
• ALTER TABLE
• ALTER TABLE - ADD clauses for columns
• ALTER TABLE - ADD clause for standard indexes
• ALTER TABLE - ADD clause for FULLTEXT indexes
• ALTER TABLE - ADD clause for SPATIAL indexes
• ALTER TABLE - ADD clauses for foreign keys
• ALTER TABLE - CHANGE clauses
• ALTER TABLE - DROP column clause
• ALTER TABLE - DROP index clauses
• ALTER TABLE - Miscellaneous clauses
• ALTER TABLE - Partition altering clauses
• ALTER TABLE - Partition administration clauses
• ALTER TABLE - Table options
• FLUSH
• LOCK TABLES
• UNLOCK TABLES
• ALTER EVENT
• RENAME TABLE
• CREATE EVENT
• DROP TABLE
• DROP EVENT
• SHOW TABLES
• SHOW CREATE EVENT
• SHOW CREATE TABLE
• SHOW EVENTS
• DESCRIBE
• DO
• HANDLER
• LOAD DATA INFILE
• SHOW ERRORS
• SHOW WARNINGS
• TRUNCATE
• EXPLAIN
• ANALYZE TABLE
• CHECK TABLE
• OPTIMIZE TABLE
• REPAIR TABLE
• SHOW COLUMNS
• CREATE VIEW
• ALTER VIEW
• DROP VIEW
• SHOW SCHEMAS
• SHOW TABLE STATUS
• SHOW VIEWS
• SHOW ENGINE
• SHOW ENGINES
• SHOW OPEN TABLES
• SHOW PLUGINS
• SHOW STATUS
• SHOW TABLE STATUS
• SHOW VARIABLES
• ALTER FUNCTION
• SHOW PROCESSLIST
• SHOW CREATE VIEW
• CREATE FUNCTION
• CREATE INDEX
• DROP FUNCTION
• DROP INDEX
• SHOW CREATE FUNCTION
• SHOW INDEXES
• SHOW FUNCTION CODE
• CREATE SERVER
• CREATE SERVER
• SHOW FUNCTION STATUS
• ALTER SERVER
• DROP SERVER
• ALTER PROCEDURE
• CREATE PROCEDURE
• SHOW CHARACTER SET
• SHOW COLLATION
• DROP PROCEDURE
• SHOW CREATE PROCEDURE
• SHOW PROCEDURE CODE
• SHOW PROCEDURE STATUS
• ALTER TRIGGER
• BEGIN...END
• CALL
• CLOSE
• CREATE TRIGGER
• DECLARE
• DELIMITER
• DROP PREPARE
• DROP TRIGGER
• EXECUTE
• FETCH
• OPEN
• PREPARE
• SHOW TRIGGERS

MySQL Clauses

• LIMIT
• JOIN
• JOIN - Index Hints
• UNION

MySQL Functions

• ANALYSE( )
• BENCHMARK( )
• DATABASE( )
• FOUND_ROWS( )
• LAST_INSERT_ID( )
• ROW_COUNT( )
• UUID ( )
• VERSION( )
• AVG( )
• BIT_AND( )
• BIT_OR( )
• BIT_XOR( )
• COUNT( )
• GROUP_CONCAT( )
• MAX( )
• MIN( )
• STD( )
• STDDEV( )
• STDDEV_POP( )
• STDDEV_SAMP( )
• SUM( )
• VAR_POP( )
• VAR_SAMP( )
• VARIANCE( )
• ASCII( )
• BIN( )
• BINARY
• BIT_LENGTH( )
• CAST( )
• CHAR( )
• CHAR_LENGTH( )
• CHARACTER_LENGTH( )
• CHARSET( )
• COALESCE( )
• COERCIBILITY( )
• COLLATION( )
• COMPRESS( )
• CONCAT( )
• CONVERT( )
• CRC32( )
• ELT( )
• EXPORT_SET( )
• FIELD( )
• FIND_IN_SET( )
• HEX( )
• INSERT( )
• INSTR( )
• INTERVAL( )
• LCASE( )
• LEFT( )
• LENGTH( )
• LOAD_FILE( )
• LOCATE( )
• LOWER( )
• LPAD( )
• LTRIM( )
• MAKE_SET()
• MATCH ( ) AGAINST( )
• MID()
• OCTET_LENGTH( )
• ORD( )
• POSITION( )
• QUOTE( )
• REPEAT( )
• REPLACE( )
• REVERSE( )
• RIGHT( )
• RPAD( )
• RTRIM( )
• SOUNDEX( )
• SPACE( )
• STRCMP( )
• SUBSTR( )
• SUBSTRING( )
• SUBSTRING_INDEX( )
• TRIM( )
• UCASE( )
• UNCOMPRESS( )
• UNCOMPRESSED_LENGTH( )
• UNHEX( )
• UPPER( )
• ADDDATE( )
• ADDTIME( )
• CONVERT_TZ( )
• CURDATE()
• CURRENT_DATE( )
• CURRENT_TIME( )
• CURRENT_TIMESTAMP()
• CURTIME()
• DATE( )
• DATE_ADD( )
• DATE_FORMAT( )
• DATE_SUB( )
• DATEDIFF( )
• DAY( )
• DAYNAME( )
• DAYOFMONTH( )
• DAYOFWEEK( )
• DAYOFYEAR( )
• EXTRACT( )
• FROM_DAYS( )
• FROM_UNIXTIME( )
• GET_FORMAT( )
• HOUR( )
• LAST_DAY( )
• LOCALTIME( )
• LOCALTIMESTAMP( )
• MAKEDATE( )
• MAKETIME( )
• MICROSECOND( )
• MINUTE( )
• MONTH( )
• MONTHNAME( )
• NOW( )
• PERIOD_ADD( )
• PERIOD_DIFF( )
• QUARTER( )
• SEC_TO_TIME( )
• SECOND( )
• SLEEP( )
• STR_TO_DATE( )
• SUBDATE( )
• SUBTIME( )
• SYSDATE( )
• TIME( )
• TIME_FORMAT( )
• TIME_TO_SEC( )
• TIMEDIFF( )
• TIMESTAMP( )
• TIMESTAMPADD( )
• TIMESTAMPDIFF( )
• TO_DAYS( )
• UNIX_TIMESTAMP( )
• UTC_DATE( )
• UTC_TIME( )
• UTC_TIMESTAMP( )
• WEEK( )
• WEEKDAY( )
• WEEKOFYEAR( )
• YEAR( )
• YEARWEEK( )
• ABS( )
• ACOS( )
• ASIN( )
• COT( )
• CONV( )
• COS( )
• CEILING( )
• CEIL( )
• BIT_COUNT( )
• ACOS( )
• ASIN( )
• ATAN( )
• ATAN2( )
• DEGREES( )
• EXP( )
• FLOOR( )
• FORMAT( )
• GREATEST( )
• INET_ATON( )
• INET_NTOA( )
• LEAST( )
• LN( )
• LOG( )
• LOG2( )
• LOG10( )
• MOD( )
• OCT( )
• PI( )
• POW( )
• POWER( )
• RADIANS( )
• RAND( )
• ROUND( )
• SIGN( )
• SIN( )
• SQRT( )
• TAN( )
• TRUNCATE( )
• IF( )
• CASE
• IFNULL( )
• ISNULL( )
• NULLIF( )
• PASSWORD( )
• OLD_PASSWORD( )
• AES_DECRYPT( )
• AES_ENCRYPT( )
• CURRENT_USER( )
• DECODE( )
• DES_DECRYPT( )
• DES_ENCRYPT( )
• ENCODE( )
• ENCRYPT( )
• MD5( )
• SHA( )
• SHA( )
• SESSION_USER( )
• SYSTEM_USER( )
• USER( )
• SCHEMA( )
• CONNECTION_ID( )
• GET_LOCK( )
• IS_FREE_LOCK( )
• IS_USED_LOCK( )
• RELEASE_LOCK( )