Go to the first, previous, next, last section, table of contents.

SQL command, type and function index

• ! (logical NOT)
• != (not equal)
• "
• % (modulo)
• % (wildcard character)
• & (bitwise AND)
• && (logical AND)
• () (parentheses)
• * (multiplication)
• + (addition)
• - (subtraction)
• - (unary minus)
• .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file
• .mysql_history file
• .pid (process ID) file
• / (division)
• /etc/passwd, /etc/passwd
• < (less than)
• << (left shift)
• <= (less than or equal)
• <=> (Equal to)
• <> (not equal)
• = (equal)
• > (greater than)
• >= (greater than or equal)
• >> (right shift)
• \" (double quote)
• \' (single quote)
• \0 (ASCII 0)
• \\ (escape)
• \b (backspace)
• \n (newline)
• \r (carriage return)
• \t (tab)
• _ (wildcard character)
• `

A

• ABS()
• ACOS()
• ADDDATE()
• addition (+)
• alias
• ALTER TABLE
• AND, bitwise
• AND, logical
• Arithmetic functions
• ASCII()
• ASIN()
• ATAN()
• ATAN2()
• AUTO_INCREMENT, using with DBI
• AVG()

B

• backspace (\b)
• BENCHMARK()
• BETWEEN ... AND
• BIGINT
• BIN()
• BINARY
• Bit functions
• BIT_AND()
• BIT_COUNT()
• BIT_OR()
• BLOB, BLOB

C

• carriage return (\r)
• CASE
• Casts
• CC environment variable, CC environment variable
• CEILING()
• CFLAGS environment variable
• CHAR, CHAR
• CHAR VARYING
• CHAR()
• CHAR_LENGTH()
• CHARACTER
• CHARACTER VARYING
• CHARACTER_LENGTH()
• ChopBlanks DBI method
• COALESCE()
• Comment syntax
• Comparison operators
• CONCAT()
• connect() DBI method
• Control flow functions
• CONV()
• COS()
• COT()
• COUNT()
• COUNT(DISTINCT)
• CREATE DATABASE
• CREATE FUNCTION
• CREATE INDEX
• CREATE TABLE
• CROSS JOIN
• CURDATE()
• CURRENT_DATE
• CURRENT_TIME
• CURRENT_TIMESTAMP
• CURTIME()
• CXX environment variable, CXX environment variable, CXX environment variable, CXX environment variable
• CXXFLAGS environment variable, CXXFLAGS environment variable

D

• data_sources() DBI method
• DATABASE()
• DATE, DATE
• Date and time functions
• DATE_ADD()
• DATE_FORMAT()
• DATE_SUB()
• DATETIME, DATETIME
• DAYNAME()
• DAYOFMONTH()
• DAYOFWEEK()
• DAYOFYEAR()
• DBI->connect()
• DBI->data_sources()
• DBI->disconnect
• DBI->do()
• DBI->execute
• DBI->fetchall_arrayref
• DBI->fetchrow_array
• DBI->fetchrow_arrayref
• DBI->fetchrow_hashref
• DBI->finish
• DBI->prepare()
• DBI->quote
• DBI->quote()
• DBI->rows
• DBI->trace, DBI->trace
• DBI->{ChopBlanks}
• DBI->{insertid}
• DBI->{is_blob}
• DBI->{is_key}
• DBI->{is_not_null}
• DBI->{is_num}
• DBI->{is_pri_key}
• DBI->{length}
• DBI->{max_length}
• DBI->{NAME}
• DBI->{NULLABLE}
• DBI->{NUM_OF_FIELDS}
• DBI->{table}
• DBI->{type}
• DBI_TRACE environment variable, DBI_TRACE environment variable
• DECIMAL
• DECODE()
• DEGREES()
• DELAYED
• DELETE
• DESC
• DESCRIBE
• disconnect DBI method
• DISTINCT, DISTINCT
• division (/)
• do() DBI method
• DOUBLE
• DOUBLE PRECISION
• double quote (\")
• DROP DATABASE
• DROP FUNCTION
• DROP INDEX
• DROP TABLE
• DUMPFILE

E

• ELT()
• ENCODE()
• ENCRYPT()
• ENUM, ENUM
• Environment variable, CC, Environment variable, CC
• Environment variable, CFLAGS
• Environment variable, CXX, Environment variable, CXX, Environment variable, CXX
• Environment variable, CXXFLAGS, Environment variable, CXXFLAGS
• Environment variable, DBI_TRACE, Environment variable, DBI_TRACE
• Environment variable, HOME
• Environment variable, LD_RUN_PATH, Environment variable, LD_RUN_PATH, Environment variable, LD_RUN_PATH
• Environment variable, MYSQL_DEBUG, Environment variable, MYSQL_DEBUG
• Environment variable, MYSQL_HISTFILE
• Environment variable, MYSQL_HOST
• Environment variable, MYSQL_PWD, Environment variable, MYSQL_PWD
• Environment variable, MYSQL_TCP_PORT, Environment variable, MYSQL_TCP_PORT, Environment variable, MYSQL_TCP_PORT
• Environment variable, MYSQL_UNIX_PORT, Environment variable, MYSQL_UNIX_PORT, Environment variable, MYSQL_UNIX_PORT, Environment variable, MYSQL_UNIX_PORT
• Environment variable, PATH
• Environment variable, TMPDIR
• Environment variable, TZ, Environment variable, TZ, Environment variable, TZ
• Environment variable, UMASK
• Environment variable, USER
• Environment variables, CXX
• equal (=)
• escape (\\)
• execute DBI method
• EXP()
• EXPLAIN
• EXPORT_SET()
• EXTRACT(type FROM date)

F

• fetchall_arrayref DBI method
• fetchrow_array DBI method
• fetchrow_arrayref DBI method
• fetchrow_hashref DBI method
• FIELD()
• FILE
• FIND_IN_SET()
• finish DBI method
• FLOAT, FLOAT
• FLOAT(M,D)
• FLOAT(precision), FLOAT(precision)
• FLOAT(precision) [ZEROFILL]
• FLOOR()
• FLUSH
• FORMAT()
• FROM_DAYS()
• FROM_UNIXTIME(), FROM_UNIXTIME()
• Functions, arithmetic
• Functions, bit
• Functions, control flow
• Functions, date and time
• Functions, GROUP BY
• Functions, logical
• Functions, mathematical
• Functions, miscellaneous
• Functions, string
• Functions, string comparison
• Functions, user-defined

G

• GET_LOCK()
• GRANT
• greater than (>)
• greater than or equal (>=)
• GREATEST()
• GROUP BY functions

H

• HEX()
• Hexadecimal values
• HOME environment variable
• host.frm, problems finding
• HOUR()

I

• IF()
• IFNULL()
• IN
• INNER JOIN
• INSERT
• INSERT DELAYED
• INSERT()
• insertid DBI method
• INSTR()
• INT
• INTEGER
• INTERVAL()
• IS NOT NULL
• IS NULL
• IS NULL, and indexes
• is_blob DBI method
• is_key DBI method
• is_not_null DBI method
• is_num DBI method
• is_pri_key DBI method
• ISNULL()

J

• JOIN

K

• KILL

L

• LAST_INSERT_ID()
• LAST_INSERT_ID([expr])
• LCASE()
• LD_RUN_PATH environment variable, LD_RUN_PATH environment variable, LD_RUN_PATH environment variable
• LEAST()
• LEFT JOIN
• LEFT OUTER JOIN
• LEFT()
• length DBI method
• LENGTH()
• less than (<)
• less than or equal (<=)
• LIKE
• LIKE, and indexes
• LIKE, and wildcards
• LOAD DATA INFILE, LOAD DATA INFILE
• LOCATE(), LOCATE()
• LOCK TABLES
• LOG()
• LOG10()
• Logical functions
• LONGBLOB
• LONGTEXT
• LOWER()
• LPAD()
• LTRIM()

M

• MAKE_SET()
• Mathematical functions
• MAX()
• max_length DBI method
• MD5()
• MEDIUMBLOB
• MEDIUMINT
• MEDIUMTEXT
• MID()
• MIN()
• minus, unary (-)
• MINUTE()
• Miscellaneous functions
• MOD()
• modulo (%)
• MONTH()
• MONTHNAME()
• multiplication (*)
• my_ulonglong C type
• my_ulonglong values, printing
• MYSQL C type
• mysql_affected_rows()
• mysql_change_user()
• mysql_close()
• mysql_connect()
• mysql_create_db()
• mysql_data_seek()
• MYSQL_DEBUG environment variable, MYSQL_DEBUG environment variable
• mysql_debug()
• mysql_drop_db()
• mysql_dump_debug_info()
• mysql_eof()
• mysql_errno()
• mysql_error()
• mysql_escape_string()
• mysql_escape_string()
• mysql_fetch_field()
• mysql_fetch_field_direct()
• mysql_fetch_fields()
• mysql_fetch_lengths()
• mysql_fetch_row()
• MYSQL_FIELD C type
• mysql_field_count(), mysql_field_count()
• MYSQL_FIELD_OFFSET C type
• mysql_field_seek()
• mysql_field_tell()
• mysql_free_result()
• mysql_get_client_info()
• mysql_get_host_info()
• mysql_get_proto_info()
• mysql_get_server_info()
• MYSQL_HISTFILE environment variable
• MYSQL_HOST environment variable
• mysql_info(), mysql_info(), mysql_info(), mysql_info()
• mysql_info()
• mysql_init()
• mysql_insert_id()
• mysql_insert_id()
• mysql_kill()
• mysql_list_dbs()
• mysql_list_fields()
• mysql_list_processes()
• mysql_list_tables()
• mysql_num_fields()
• mysql_num_rows()
• mysql_options()
• mysql_ping()
• MYSQL_PWD environment variable, MYSQL_PWD environment variable
• mysql_query()
• mysql_real_connect()
• mysql_real_query()
• mysql_reload()
• MYSQL_RES C type
• MYSQL_ROW C type
• mysql_row_seek()
• mysql_row_tell()
• mysql_select_db()
• mysql_shutdown()
• mysql_stat()
• mysql_store_result()
• MYSQL_TCP_PORT environment variable, MYSQL_TCP_PORT environment variable, MYSQL_TCP_PORT environment variable
• mysql_thread_id()
• MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable
• mysql_use_result()

N

• NAME DBI method
• NATIONAL CHAR
• NATURAL LEFT JOIN
• NATURAL LEFT OUTER JOIN
• NCHAR
• newline (\n)
• not equal (!=)
• not equal (<>)
• NOT IN
• NOT LIKE
• NOT REGEXP
• NOT, logical
• NOW()
• NUL
• NULL
• NULL value
• NULLABLE DBI method
• NUM_OF_FIELDS DBI method
• NUMERIC

O

• OCT()
• OCTET_LENGTH()
• OPTIMIZE TABLE
• OR, bitwise
• OR, logical
• ORD()

P

• parentheses ( and )
• PASSWORD(), PASSWORD(), PASSWORD(), PASSWORD()
• PATH environment variable
• PERIOD_ADD()
• PERIOD_DIFF()
• PI()
• POSITION()
• POW()
• POWER()
• prepare() DBI method
• PROCESSLIST

Q

• QUARTER()
• quote() DBI method
• Quoting of identifiers

R

• RADIANS()
• RAND()
• REAL
• REGEXP
• RELEASE_LOCK()
• REPEAT()
• REPLACE
• REPLACE()
• return (\r)
• REVERSE()
• REVOKE
• RIGHT()
• RLIKE
• ROUND(), ROUND()
• rows DBI method
• RPAD()
• RTRIM()

S

• SEC_TO_TIME()
• SECOND()
• SELECT
• SELECT, optimizing
• SESSION_USER()
• SET, SET
• SET OPTION
• SHOW COLUMNS
• SHOW DATABASES
• SHOW FIELDS
• SHOW GRANTS
• SHOW INDEX
• SHOW KEYS
• SHOW PROCESSLIST
• SHOW STATUS
• SHOW TABLE STATUS
• SHOW TABLES
• SHOW VARIABLES
• SIGN()
• SIN()
• single quote (\')
• SMALLINT
• SOUNDEX()
• SPACE()
• SQRT()
• STD()
• STDDEV()
• STRAIGHT_JOIN
• STRCMP()
• String comparison functions
• String functions
• SUBDATE()
• SUBSTRING(), SUBSTRING()
• SUBSTRING_INDEX()
• subtraction (-)
• SUM()
• SYSDATE()
• SYSTEM_USER()

T

• tab (\t)
• table DBI method
• table_cache
• TAN()
• TEXT, TEXT
• Threads
• TIME, TIME
• TIME_FORMAT()
• TIME_TO_SEC()
• TIMESTAMP, TIMESTAMP
• TINYBLOB
• TINYINT
• TINYTEXT
• TMPDIR environment variable
• TO_DAYS()
• trace DBI method, trace DBI method
• TRIM()
• TRUNCATE()
• type DBI method
• Types
• TZ environment variable, TZ environment variable, TZ environment variable

U

• UCASE()
• UDF functions
• ulimit
• UMASK environment variable
• unary minus (-)
• UNIX_TIMESTAMP()
• UNLOCK TABLES
• UPDATE
• UPPER()
• USE
• USER environment variable
• USER()
• User-defined functions

V

• VARCHAR, VARCHAR
• VERSION()

W

• WEEK()
• WEEKDAY()
• Wildcard character (%)
• Wildcard character (_)

Y

• YEAR, YEAR
• YEAR()

• | (bitwise OR)
• || (logical OR)
• ~

Go to the first, previous, next, last section, table of contents.