Search
Happiness, it seems, is just a space away.
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
- 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
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( )
MySQL in a Nutshell
If you work with MySQL regularly and find my writing style and examples helpful, please consider buying my book, MySQL in a Nutshell . The second edition just came out: I'm very proud of it and am starting to get great reviews about it. Click on the cover art work here and you'll be taken to Amazon's site where you can purchase a copy and have it mailed to you.
