MySQL Reference Manual for version 3.23.39. - SQL command, type and function index
code {color:purple} tt {color:green} samp {color:navy} pre {color:maroon}


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



SQL command, type and function index




! (logical NOT)
!= (not equal)
"
% (modulo)
% (wild card character)
& (bitwise AND)
&& (logical AND)
() (parentheses)
(Control-Z) \z
* (multiplication)
+ (addition)
- (subtraction)
- (unary minus)
-p option
-password option
.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)
\z (Control-Z) ASCII(26)
_ (wild card character)
`

A

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

B

backspace (\b)
BACKUP TABLE
BEGIN
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, CC environment variable
CCX environment variable
CEILING()
CFLAGS environment variable, CFLAGS environment variable
CHAR, CHAR
CHAR VARYING
CHAR()
CHAR_LENGTH()
CHARACTER
CHARACTER VARYING
CHARACTER_LENGTH()
CHECK TABLE
ChopBlanks DBI method
COALESCE()
command-line options
Comment syntax
COMMIT, COMMIT
comparison operators
CONCAT()
CONCAT_WS()
configure option, --with-charset
connect() DBI method
CONNECTION_ID()
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, CXXFLAGS environment variable, CXXFLAGS environment variable

D

data_sources() DBI method
DATABASE()
DATE, 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, DBI_TRACE environment variable
DBI_USER environment variable
DECIMAL
DECODE()
DEGREES()
DELAYED
DELETE
DESC
DESCRIBE, DESCRIBE
disconnect DBI method
DISTINCT, DISTINCT, DISTINCT
division (/)
do() DBI method
DOUBLE
DOUBLE PRECISION
double quote (\")
DROP DATABASE
DROP FUNCTION
DROP INDEX, DROP INDEX
DROP PRIMARY KEY
DROP TABLE
DUMPFILE

E

ELT()
ENCODE()
ENCRYPT()
ENUM, ENUM
environment variable, CC, environment variable, CC
Environment variable, CC
Environment variable, CCX
Environment variable, CFLAGS
environment variable, CFLAGS
Environment variable, CXX
environment variable, CXX, environment variable, CXX
Environment variable, CXXFLAGS
environment variable, CXXFLAGS, environment variable, CXXFLAGS, environment variable, CXXFLAGS
Environment variable, DBI_TRACE, Environment variable, DBI_TRACE, Environment variable, DBI_TRACE
Environment variable, DBI_USER
Environment variable, HOME, Environment variable, HOME
environment variable, LD_RUN_PATH
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_DEBUG
Environment variable, MYSQL_HISTFILE, Environment variable, MYSQL_HISTFILE
Environment variable, MYSQL_HOST, Environment variable, MYSQL_HOST
Environment variable, MYSQL_PWD, 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_TCP_PORT
Environment variable, MYSQL_UNIX_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, PATH
Environment variable, TMPDIR, Environment variable, TMPDIR
Environment variable, TZ, Environment variable, TZ
Environment variable, UMASK, Environment variable, UMASK
Environment variable, UMASK_DIR, Environment variable, UMASK_DIR
Environment variable, USER, 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)
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
GRANT statement
greater than (>)
greater than or equal (>=)
GREATEST()
GROUP BY functions

H

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

I

identifiers, quoting
IF()
IFNULL()
IN
INET_ATON()
INET_NTOA()
INNER JOIN
INSERT
INSERT ... SELECT
INSERT DELAYED
INSERT statement, grant privileges
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()
ISOLATION LEVEL

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, LD_RUN_PATH environment variable
LEAST()
LEFT JOIN, LEFT JOIN
LEFT OUTER JOIN
LEFT()
length DBI method
LENGTH()
less than (<)
less than or equal (<=)
LIKE
LIKE, and indexes
LIKE, and wildcards
LIMIT
LOAD DATA INFILE, LOAD DATA INFILE
LOAD_FILE()
LOCATE(), LOCATE()
LOCK TABLES
LOG()
LOG10()
Logical functions
LONGBLOB
LONGTEXT
LOWER()
LPAD()
LTRIM()

M

MAKE_SET()
MASTER_POS_WAIT()
MATCH ... AGAINST()
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_character_set_name()
mysql_close()
mysql_connect()
mysql_create_db()
mysql_data_seek()
MYSQL_DEBUG environment variable, 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_HISTFILE environment variable
MYSQL_HOST 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_PWD environment variable
mysql_query(), mysql_query()
mysql_real_connect()
mysql_real_escape_string()
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_store_result()
MYSQL_TCP_PORT environment variable, 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_UNIX_PORT environment variable
mysql_use_result()

N

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

O

OCT()
OCTET_LENGTH()
OPTIMIZE TABLE
OR, bitwise
OR, logical
ORD()
ORDER BY

P

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

Q

QUARTER()
quote() DBI method
quoting of identifiers

R

RADIANS()
RAND()
REAL
REGEXP
RELEASE_LOCK()
RENAME TABLE
REPAIR TABLE
REPEAT()
REPLACE
REPLACE ... SELECT
REPLACE()
RESTORE TABLE
return (\r)
REVERSE()
REVOKE
RIGHT JOIN
RIGHT OUTER JOIN
RIGHT()
RLIKE
ROLLBACK, ROLLBACK
ROUND(), ROUND()
rows DBI method
RPAD()
RTRIM()

S

SEC_TO_TIME()
SECOND()
SELECT
SELECT INTO TABLE
SELECT speed
SELECT, optimizing
SESSION_USER()
SET, SET
SET OPTION
SET PASSWORD statement
SHOW COLUMNS, SHOW COLUMNS
SHOW CREATE TABLE
SHOW DATABASES, SHOW DATABASES
SHOW FIELDS, SHOW FIELDS
SHOW GRANTS
SHOW INDEX, SHOW INDEX
SHOW KEYS, SHOW KEYS
SHOW MASTER LOGS
SHOW MASTER STATUS
SHOW PROCESSLIST
SHOW SLAVE STATUS
SHOW STATUS
SHOW TABLE STATUS
SHOW TABLES, SHOW TABLES
SHOW VARIABLES
SIGN()
SIN()
single quote (\')
SMALLINT
SOUNDEX()
SPACE()
SQRT()
statements, GRANT
statements, INSERT
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, TMPDIR environment variable
TO_DAYS()
trace DBI method, trace DBI method
TRIM()
TRUNCATE
TRUNCATE()
type DBI method
Types
TZ environment variable, TZ environment variable

U

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

V

VARCHAR, VARCHAR
VERSION()

W

WEEK()
WEEKDAY()
WHERE
Wild card character (%)
Wild card character (_)
without-server option

Y

YEAR, YEAR
YEAR()



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




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