MySQL Documentation - Alphabetical List

This is a 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 Statement

ALTER DATABASE
DROP VIEW
SHOW CHARACTER SET
ALTER EVENT
EXECUTE
SHOW COLLATION
ALTER FUNCTION
EXPLAIN
SHOW COLUMNS
ALTER PROCEDURE
FETCH
SHOW CREATE DATABASE
ALTER SCHEMA
FLUSH
SHOW CREATE EVENT
ALTER SERVER
GRANT
SHOW CREATE FUNCTION
ALTER TABLE
HANDLER
SHOW CREATE PROCEDURE
ALTER TRIGGER
HELP
SHOW CREATE TABLE
ALTER VIEW
INSERT
SHOW CREATE VIEW
ANALYZE TABLE
KILL
SHOW DATABASES
BACKUP TABLE
LOAD DATA FROM MASTER
SHOW ENGINE
BEGIN
LOAD DATA INFILE
SHOW ENGINES
BEGIN...END
LOAD INDEX INTO CACHE
SHOW ERRORS
CACHE INDEX
LOAD TABLE...FROM MASTER
SHOW EVENTS
CALL
LOCK TABLES
SHOW FUNCTION CODE
CHANGE MASTER TO
MASTER_POS_WAIT( )
SHOW FUNCTION STATUS
CHECK TABLE
Multiple Fields Subqueries
SHOW GRANTS
CHECKSUM TABLE
OPEN
SHOW INDEXES
CLOSE
OPTIMIZE TABLE
SHOW MASTER LOGS
COMMIT
PREPARE
SHOW MASTER STATUS
CREATE DATABASE
PURGE MASTER LOGS
SHOW OPEN TABLES
CREATE EVENT
RELEASE SAVEPOINT
SHOW PLUGINS
CREATE FUNCTION
RENAME DATABASE
SHOW PRIVILEGES
CREATE INDEX
RENAME TABLE
SHOW PROCEDURE CODE
CREATE PROCEDURE
RENAME USER
SHOW PROCEDURE STATUS
CREATE SCHEMA
REPAIR TABLE
SHOW PROCESSLIST
CREATE SERVER
REPLACE
SHOW SCHEMAS
CREATE TABLE
RESET
SHOW SLAVE HOSTS
CREATE TRIGGER
RESET
SHOW SLAVE STATUS
CREATE USER
RESET MASTER
SHOW STATUS
CREATE VIEW
RESET SLAVE
SHOW TABLE STATUS
DECLARE
RESTORE TABLE
SHOW TABLE STATUS
DELETE
Results Set Subqueries
SHOW TABLES
DELIMITER
REVOKE
SHOW TRIGGERS
DESCRIBE
ROLLBACK
SHOW VARIABLES
DO
ROLLBACK TO SAVEPOINT
SHOW VIEWS
DROP DATABASE
SAVEPOINT
SHOW WARNINGS
DROP EVENT
SELECT
Single Field Subqueries
DROP FUNCTION
SET
START SLAVE
DROP INDEX
SET
START TRANSACTION
DROP PREPARE
SET GLOBAL SQL_SLAVE_SKIP_COUNTER
STOP SLAVE
DROP PROCEDURE
SET PASSWORD
TRUNCATE
DROP SERVER
SET SQL_LOG_BIN
UNLOCK TABLES
DROP TABLE
SET TRANSACTION
UPDATE
DROP TRIGGER
SHOW BINARY LOGS
USE
DROP USER
SHOW BINLOG EVENTS
XA

MySQL Function

ABS( )
EXTRACT( )
RADIANS( )
ACOS( )
FIELD( )
RAND( )
ACOS( )
FIND_IN_SET( )
RELEASE_LOCK( )
ADDDATE( )
FLOOR( )
REPEAT( )
ADDTIME( )
FORMAT( )
REPLACE( )
AES_DECRYPT( )
FOUND_ROWS( )
REVERSE( )
AES_ENCRYPT( )
FROM_DAYS( )
RIGHT( )
ANALYSE( )
FROM_UNIXTIME( )
ROUND( )
ASCII( )
GET_FORMAT( )
ROW_COUNT( )
ASIN( )
GET_LOCK( )
RPAD( )
ASIN( )
GREATEST( )
RTRIM( )
ATAN( )
GROUP_CONCAT( )
SCHEMA( )
ATAN2( )
HEX( )
SECOND( )
AVG( )
HOUR( )
SEC_TO_TIME( )
BENCHMARK( )
IF( )
SESSION_USER( )
BIN( )
IFNULL( )
SHA( )
BINARY
INET_ATON( )
SHA( )
BIT_AND( )
INET_NTOA( )
SIGN( )
BIT_COUNT( )
INSERT( )
SIN( )
BIT_LENGTH( )
INSTR( )
SLEEP( )
BIT_OR( )
INTERVAL( )
SOUNDEX( )
BIT_XOR( )
ISNULL( )
SPACE( )
CASE
IS_FREE_LOCK( )
SQRT( )
CAST( )
IS_USED_LOCK( )
STD( )
CEIL( )
LAST_DAY( )
STDDEV( )
CEILING( )
LAST_INSERT_ID( )
STDDEV_POP( )
CHAR( )
LCASE( )
STDDEV_SAMP( )
CHARACTER_LENGTH( )
LEAST( )
STRCMP( )
CHARSET( )
LEFT( )
STR_TO_DATE( )
CHAR_LENGTH( )
LENGTH( )
SUBDATE( )
COALESCE( )
LN( )
SUBSTR( )
COERCIBILITY( )
LOAD_FILE( )
SUBSTRING( )
COLLATION( )
LOCALTIME( )
SUBSTRING_INDEX( )
COMPRESS( )
LOCALTIMESTAMP( )
SUBTIME( )
CONCAT( )
LOCATE( )
SUM( )
CONNECTION_ID( )
LOG( )
SYSDATE( )
CONV( )
LOG10( )
SYSTEM_USER( )
CONVERT( )
LOG2( )
TAN( )
CONVERT_TZ( )
LOWER( )
TIME( )
COS( )
LPAD( )
TIMEDIFF( )
COT( )
LTRIM( )
TIMESTAMP( )
COUNT( )
MAKEDATE( )
TIMESTAMPADD( )
CRC32( )
MAKETIME( )
TIMESTAMPDIFF( )
CURDATE()
MAKE_SET()
TIME_FORMAT( )
CURRENT_DATE( )
MATCH ( ) AGAINST( )
TIME_TO_SEC( )
CURRENT_TIME( )
MAX( )
TO_DAYS( )
CURRENT_TIMESTAMP()
MD5( )
TRIM( )
CURRENT_USER( )
MICROSECOND( )
TRUNCATE( )
CURTIME()
MID()
UCASE( )
DATABASE( )
MIN( )
UNCOMPRESS( )
DATE( )
MINUTE( )
UNCOMPRESSED_LENGTH( )
DATEDIFF( )
MOD( )
UNHEX( )
DATE_ADD( )
MONTH( )
UNIX_TIMESTAMP( )
DATE_FORMAT( )
MONTHNAME( )
UPPER( )
DATE_SUB( )
NOW( )
USER( )
DAY( )
NULLIF( )
UTC_DATE( )
DAYNAME( )
OCT( )
UTC_TIME( )
DAYOFMONTH( )
OCTET_LENGTH( )
UTC_TIMESTAMP( )
DAYOFWEEK( )
OLD_PASSWORD( )
UUID ( )
DAYOFYEAR( )
ORD( )
VARIANCE( )
DECODE( )
PASSWORD( )
VAR_POP( )
DEGREES( )
PERIOD_ADD( )
VAR_SAMP( )
DES_DECRYPT( )
PERIOD_DIFF( )
VERSION( )
DES_ENCRYPT( )
PI( )
WEEK( )
ELT( )
POSITION( )
WEEKDAY( )
ENCODE( )
POW( )
WEEKOFYEAR( )
ENCRYPT( )
POWER( )
YEAR( )
EXP( )
QUARTER( )
YEARWEEK( )
EXPORT_SET( )
QUOTE( )
available_drivers( )
mysql_data_seek( )
mysql_num_rows( )
begin_work( )
mysql_db_name( )
mysql_pconnect( )
bind_col( )
mysql_db_query( )
mysql_ping( )
bind_columns( )
mysql_debug( )
mysql_ping( )
bind_param( )
mysql_drop_db( )
mysql_query( )
bind_param_array( )
mysql_drop_db( )
mysql_query( )
bind_param_inout( )
mysql_dump_debug_info( )
mysql_real_connect( )
can( )
mysql_eof( )
mysql_real_escape_string( )
clone( )
mysql_errno( )
mysql_real_escape_string( )
column_info( )
mysql_errno( )
mysql_real_query( )
commit( )
mysql_error( )
mysql_refresh( )
connect( )
mysql_error( )
mysql_reload( )
connect_cached( )
mysql_escape_string( )
mysql_result( )
CONV_ACRE_SQKM
mysql_escape_string( )
mysql_rollback( )
CONV_FT_MT
mysql_fetch_array( )
mysql_row_seek( )
CONV_GAL
mysql_fetch_assoc( )
mysql_row_tell( )
CONV_IN_CM
mysql_fetch_field( )
mysql_select_db( )
CONV_MI_KM
mysql_fetch_field( )
mysql_select_db( )
CONV_SQFT_MT
mysql_fetch_fields( )
mysql_set_character_set( )
CONV_TEMP
mysql_fetch_field_direct( )
mysql_set_charset( )
data_diff( )
mysql_fetch_lengths( )
mysql_set_local_infile_default( )
data_sources( )
mysql_fetch_lengths( )
mysql_set_local_infile_handler( )
data_string_desc( )
mysql_fetch_object( )
mysql_set_server_option( )
data_string_diff( )
mysql_fetch_row( )
mysql_shutdown( )
DAYS_TO
mysql_fetch_row( )
mysql_sqlstate( )
DAYS_TO_XMAS
mysql_field_count( )
mysql_ssl_set( )
DAYS_TO_YEAR_END
mysql_field_flags( )
mysql_stat( )
DELTA_PCT
mysql_field_len( )
mysql_stat( )
DELTA_PCT_FMT
mysql_field_name( )
mysql_store_result( )
disconnect( )
mysql_field_seek( )
mysql_tablename( )
do( )
mysql_field_seek( )
mysql_thread_end( )
dump_results( )
mysql_field_table( )
mysql_thread_id( )
err( )
mysql_field_tell( )
mysql_thread_id( )
errstr( )
mysql_field_type( )
mysql_thread_init( )
execute( )
mysql_free_result( )
mysql_thread_safe( )
execute_array( )
mysql_free_result( )
mysql_unbuffered_query( )
execute_for_fetch( )
mysql_get_character_set_info( )
mysql_use_result( )
fetch( )
mysql_get_client_info( )
mysql_warning_count( )
fetchall_arrayref( )
mysql_get_client_info( )
neat( )
fetchall_hashref( )
mysql_get_client_version( )
neat_list( )
fetchrow_array( )
mysql_get_host_info( )
parse_dsn( )
fetchrow_arrayref( )
mysql_get_host_info( )
parse_trace_flag( )
fetchrow_hashref( )
mysql_get_proto_info( )
parse_trace_flags( )
finish( )
mysql_get_proto_info( )
ping( )
FIRST_DAY
mysql_get_server_info( )
PMT
foreign_key_info( )
mysql_get_server_info( )
prepare( )
func( )
mysql_get_server_version( )
primary_key( )
FV
mysql_get_ssl_cipher( )
primary_key_info( )
get_info( )
mysql_hex_string( )
private_attribute_info( )
installed_drivers( )
mysql_info( )
quote( )
installed_versions( )
mysql_info( )
quote_identifier( )
IS_NUMERIC
mysql_init( )
rollback( )
ITAL_DAYNAME
mysql_insert_id( )
rows( )
last_insert_id( )
mysql_insert_id( )
selectall_arrayref( )
LAST_QTR[_YR]
mysql_kill( )
selectall_hashref( )
looks_like_number( )
mysql_library_end( )
selectcol_arrayref( )
mysql_affected_rows( )
mysql_library_init( )
selectrow_array( )
mysql_autocommit( )
mysql_list_dbs( )
selectrow_arrayref( )
mysql_change_user( )
mysql_list_dbs( )
selectrow_hashref( )
mysql_change_user( )
mysql_list_fields( )
set_err( )
mysql_character_set_name( )
mysql_list_fields( )
state( )
mysql_client_encoding( )
mysql_list_processes( )
statistics_info( )
mysql_close( )
mysql_list_processes( )
swap_inner_handle( )
mysql_close( )
mysql_list_tables( )
tables( )
mysql_commit( )
mysql_list_tables( )
table_info( )
mysql_connect( )
mysql_more_results( )
take_imp_data( )
mysql_connect( )
mysql_next_result( )
trace( )
mysql_create_db( )
mysql_num_fields( )
trace_msg( )
mysql_create_db( )
mysql_num_fields( )
type_info( )
mysql_data_seek( )
mysql_num_rows( )
type_info_all( )