Go to the first, previous, next, last section, table of contents.
! (logical NOT)
!= (not equal)
% (modulo)
% (wildcard character)
& (bitwise AND)
&& (logical AND)
() (parentheses)
* (multiplication)
+ (addition)
- (minus)
- (subtraction)
.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 file
/ (division)
< (less than)
<< (left shift)
<= (less than or equal)
<> (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, and NULL values
AUTO_INCREMENT, using with DBI
AVG()
B
backspace (\b)
BETWEEN ... AND
BIGINT
BIN()
Bit functions
BIT_AND()
BIT_COUNT()
BIT_OR()
BLOB, BLOB
C
carriage return (\r)
CC environment variable, CC environment variable
CEILING()
CFLAGS environment variable
CHAR, CHAR
CHAR()
CHAR_LENGTH()
CHARACTER_LENGTH()
ChopBlanks
Comment syntax
Comparison operators
CONCAT()
connect()
Control flow functions
CONV()
COS()
COT()
COUNT()
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()
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->{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}
DECIMAL
DEGREES()
DELAYED
DELETE
DESC
DESCRIBE
disconnect
division (/)
do()
DOUBLE
DOUBLE PRECISION
double quote (\")
DROP DATABASE
DROP FUNCTION
DROP INDEX
DROP TABLE
E
ELT()
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, HOME
Environment variable, LOGIN
Environment variable, LOGNAME
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, USER
Environment variables, CXX
equal (=)
escape (\\)
execute
EXP()
EXPLAIN
F
fetchall_arrayref
fetchrow_array
fetchrow_arrayref
fetchrow_hashref
FIELD()
FIND_IN_SET()
finish
FLOAT
FLOAT(4)
FLOAT(8)
FLOAT(M,D)
FLOOR()
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()
HOME environment variable
host.frm, problems finding
HOUR()
I
IF()
IFNULL()
IN
INSERT
INSERT DELAYED
INSERT()
insertid
INSTR()
INT
INTEGER
INTERVAL()
is_blob
is_key
is_not_null
is_num
is_pri_key
ISNULL()
J
JOIN
L
LAST_INSERT_ID()
LAST_INSERT_ID([expr])
LCASE()
LEAST()
LEFT JOIN
LEFT OUTER JOIN
LEFT()
length
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
LOGIN environment variable
LOGNAME environment variable
LONGBLOB
LONGTEXT
LOWER()
LPAD()
LTRIM()
M
MAKE_SET()
Mathematical functions
MAX()
max_length
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MID()
MIN()
minus (-)
MINUTE()
Miscellaneous functions
MOD()
modulo (%)
MONTH()
MONTHNAME()
multiplication (*)
mysql_affected_rows()
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_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_ping()
MYSQL_PWD environment variable, MYSQL_PWD environment variable
mysql_query()
mysql_real_connect()
mysql_real_query()
mysql_reload()
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
NATURAL LEFT JOIN
NATURAL LEFT OUTER JOIN
newline (\n)
not equal (!=)
not equal (<>)
NOT IN
NOT LIKE
NOT REGEXP
NOT, logical
NOW()
NUL
NULL, NULL
NULL value
NULL values, and AUTO_INCREMENT columns
NULL values, and TIMESTAMP columns
NULLABLE
NUM_OF_FIELDS
NUMERIC
O
OCT()
OCTET_LENGTH()
OPTIMIZE TABLE
OR, bitwise
OR, logical
P
parentheses ( and )
PASSWORD(), PASSWORD(), PASSWORD()
PATH environment variable
PERIOD_ADD()
PERIOD_DIFF()
PI()
POSITION()
POW()
POWER()
prepare()
Q
QUARTER()
quote()
R
RADIANS()
RAND()
REAL
REGEXP
RELEASE_LOCK()
REPEAT()
REPLACE
REPLACE()
return (\r)
REVERSE()
REVOKE
RIGHT()
RLIKE
ROUND(), ROUND()
rows
RPAD()
RTRIM()
S
SEC_TO_TIME()
SECOND()
SELECT
SELECT, optimizing
SESSION_USER()
SET, SET
SET OPTION
SHOW COLUMNS
SHOW DATABASES
SHOW FIELDS
SHOW INDEX, SHOW INDEX
SHOW KEYS
SHOW PROCESSLIST
SHOW 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()
SUBSTRING_INDEX()
subtraction (-)
SUM()
SYSDATE()
SYSTEM_USER()
T
tab (\t)
table
table_cache, table_cache
TAN()
TEXT, TEXT
TIME, TIME
TIME_FORMAT()
TIME_TO_SEC()
TIMESTAMP, TIMESTAMP
TIMESTAMP, and NULL values
TINYBLOB
TINYINT
TINYTEXT
TMPDIR environment variable
TO_DAYS()
TRIM()
TRUNCATE()
type
Types
U
UCASE()
UDF functions
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.