Go to the first, previous, next, last section, table of contents.
! (logical NOT)
!= (not equal)
"
% (modulo)
% (wildcard 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)
^ (bitwise XOR)
_ (wildcard character)
`
A
ABS()
ACOS()
ADDDATE()
addition (+)
ADDTIME()
AES_DECRYPT()
AES_ENCRYPT()
alias
ALTER COLUMN
ALTER TABLE, ALTER TABLE, ALTER TABLE
ANALYZE TABLE
AND, bitwise
AND, logical
Area(), Area()
arithmetic functions
AS, AS
AsBinary()
ASCII()
ASIN()
AsText()
ATAN()
ATAN2()
AUTO_INCREMENT, using with DBI
AVG()
B
backspace (\b)
BACKUP TABLE
BdMPolyFromText()
BdMPolyFromWKB()
BdPolyFromText()
BdPolyFromWKB()
BEGIN
BENCHMARK()
BETWEEN ... AND
BIGINT
BIN()
BINARY
BIT
BIT_AND()
BIT_COUNT
BIT_COUNT()
BIT_LENGTH()
BIT_OR
BIT_OR()
BLOB, BLOB
BOOL
BOOLEAN
Boundary()
Buffer()
C
C:\my.cnf file
carriage return (\r)
CASE
CAST
casts
CC
environment variable
CC environment variable, CC environment variable
CCX environment variable
CEILING()
Centroid(), Centroid()
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
COMPRESS()
CONCAT()
CONCAT_WS()
configure option, --with-charset
configure option, --with-extra-charsets
connect() DBI method
CONNECTION_ID()
constraints
Contains()
control flow functions
CONV()
CONVERT
ConvexHull()
COS()
COT()
COUNT()
COUNT(DISTINCT)
CRC32()
CREATE DATABASE
CREATE FUNCTION
CREATE INDEX
CREATE TABLE
CROSS JOIN
Crosses()
CURDATE()
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER()
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()
DATE_ADD()
DATE_FORMAT()
DATE_SUB()
DATEDIFF()
DATETIME, DATETIME
DAY()
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->{is_blob}
DBI->{is_key}
DBI->{is_not_null}
DBI->{is_num}
DBI->{is_pri_key}
DBI->{length}
DBI->{max_length}
DBI->{mysql_insertid}
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
DEC
DECIMAL
DECODE()
DEGREES()
DELAYED
DELETE
DES_DECRYPT()
DES_ENCRYPT()
DESC
DESCRIBE, DESCRIBE
Difference()
Dimension()
disconnect DBI method
Disjoint()
Distance()
DISTINCT, DISTINCT, DISTINCT
DIV
division (/)
DO
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()
EndPoint()
ENUM, ENUM
Envelope()
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_PS1
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 (=)
Equals()
escape (\\)
execute DBI method
EXP()
EXPLAIN
EXPORT_SET()
ExteriorRing()
EXTRACT()
F
FALSE
fetchall_arrayref DBI method
fetchrow_array DBI method
fetchrow_arrayref DBI method
fetchrow_hashref DBI method
FIELD()
FILE
FIND_IN_SET()
finish DBI method
FIXED
FLOAT, FLOAT
FLOAT(M,D)
FLOAT(precision), FLOAT(precision)
FLOOR()
FLUSH
FORCE INDEX, FORCE INDEX
FORMAT()
FOUND_ROWS()
FROM
FROM_DAYS()
FROM_UNIXTIME()
functions, arithmetic
functions, bit
functions, control flow
functions, date and time
functions, GROUP BY
functions, mathematical
functions, miscellaneous
functions, string
functions, string comparison
Functions, user-defined
G
GeomCollFromText()
GeomCollFromWKB()
GEOMETRY
GEOMETRYCOLLECTION
GeometryCollection()
GeometryCollectionFromText()
GeometryCollectionFromWKB()
GeometryFromText()
GeometryFromWKB()
GeometryN()
GeometryType()
GeomFromText(), GeomFromText()
GeomFromWKB(), GeomFromWKB()
GET_LOCK()
GLength(), GLength()
GRANT
GRANT statement, GRANT statement
GRANTS
greater than (>)
greater than or equal (>=)
GREATEST()
GROUP BY functions
GROUP_CONCAT()
H
HANDLER
HEX()
hexadecimal values
HOME environment variable
HOME
environment variable
host.frm, problems finding
HOUR()
I
identifiers, quoting
IF()
IFNULL()
IGNORE INDEX, IGNORE INDEX
IGNORE KEY, IGNORE KEY
IN
INET_ATON()
INET_NTOA()
INNER JOIN
INSERT, INSERT
INSERT ... SELECT
INSERT DELAYED
INSERT statement, grant privileges
INSERT()
INSTR()
INT
INTEGER
InteriorRingN()
Intersection()
Intersects()
INTERVAL()
IS NOT NULL
IS NULL, IS NULL
IS NULL, and indexes
is_blob DBI method
IS_FREE_LOCK()
is_key DBI method
is_not_null DBI method
is_num DBI method
is_pri_key DBI method
IsClosed(), IsClosed()
IsEmpty()
ISNULL()
ISOLATION LEVEL
IsRing()
IsSimple()
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, LIMIT
LineFromText()
LineFromWKB()
LINESTRING
LineString()
LineStringFromText()
LineStringFromWKB()
LN()
LOAD DATA INFILE, LOAD DATA INFILE
LOAD_FILE()
LOCATE(), LOCATE()
LOCK TABLES
LOG()
LOG10()
LOG2()
Logical operators
LONG
LONGBLOB
LONGTEXT
LOWER()
LPAD()
LTRIM()
M
MAKE_SET()
MAKEDATE()
MAKETIME()
MASTER_POS_WAIT()
MATCH ... AGAINST()
mathematical functions
MAX()
max_length DBI method
MBRContains()
MBRDisjoint()
MBREquals()
MBRIntersects()
MBROverlaps()
MBRTouches()
MBRWithin()
MD5()
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MICROSECOND()
MID()
MIN()
minus, unary (-)
MINUTE()
miscellaneous functions
MLineFromText()
MLineFromWKB()
MOD (modulo)
MOD()
modulo (%)
modulo (MOD)
MONTH()
MONTHNAME()
MPointFromText()
MPointFromWKB()
MPolyFromText()
MPolyFromWKB()
MULTILINESTRING
MultiLineString()
MultiLineStringFromText()
MultiLineStringFromWKB()
multiplication (*)
MULTIPOINT
MultiPoint()
MultiPointFromText()
MultiPointFromWKB()
MULTIPOLYGON
MultiPolygon()
MultiPolygonFromText()
MultiPolygonFromWKB()
my_init()
my_ulonglong C type
my_ulonglong values, printing
MYSQL C type
MySQL C type
mysql_affected_rows()
mysql_autocommit()
.
MYSQL_BIND C type
mysql_bind_param()
mysql_bind_result()
mysql_change_user()
mysql_character_set_name()
mysql_close()
mysql_commit()
.
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_execute()
mysql_fetch()
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_get_server_version()
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_insertid DBI attribute
mysql_kill()
mysql_list_dbs()
mysql_list_fields()
mysql_list_processes()
mysql_list_tables()
mysql_more_results()
.
mysql_next_result()
.
mysql_num_fields()
mysql_num_rows()
mysql_options()
mysql_param_count()
mysql_ping()
mysql_prepare()
mysql_prepare_result
.
MYSQL_PS1 environment variable
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_escape_string()
mysql_real_query()
mysql_reload()
MYSQL_RES C type
mysql_rollback()
.
MYSQL_ROW C type
mysql_row_seek()
mysql_row_tell()
mysql_select_db()
mysql_send_long_data()
.
mysql_server_end()
mysql_server_init()
mysql_shutdown()
mysql_sqlstate()
mysql_stat()
MYSQL_STMT C type
mysql_stmt_affected_rows()
mysql_stmt_close()
mysql_stmt_data_seek()
mysql_stmt_errno()
mysql_stmt_error()
.
mysql_stmt_num_rows()
mysql_stmt_row_seek()
mysql_stmt_row_tell()
mysql_stmt_sqlstate()
mysql_stmt_store_result()
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_end()
mysql_thread_id()
mysql_thread_init()
mysql_thread_safe()
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 BETWEEN
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
NumGeometries()
NumInteriorRings()
NumPoints()
O
OCT()
OCTET_LENGTH()
OLD_PASSWORD()
Operators, logical
OPTIMIZE TABLE
OR, bitwise
OR, logical
ORD()
ORDER BY
Overlaps()
P
parentheses ( and )
PASSWORD(), PASSWORD(), PASSWORD(), PASSWORD()
PATH environment variable, PATH environment variable
PERIOD_ADD()
PERIOD_DIFF()
PI()
POINT
Point()
PointFromText()
PointFromWKB()
PointN()
PointOnSurface(), PointOnSurface()
PolyFromText()
PolyFromWKB()
POLYGON
Polygon()
PolygonFromText()
PolygonFromWKB()
POSITION()
POW()
POWER()
prepare() DBI method
PRIMARY KEY, PRIMARY KEY
PROCESSLIST
Q
QUARTER()
QUOTE()
quote() DBI method
quoting of identifiers
R
RADIANS()
RAND()
REAL
ref_or_null
REGEXP
Related()
RELEASE_LOCK()
RENAME TABLE
REPAIR TABLE
REPEAT()
REPLACE
REPLACE ... SELECT
REPLACE()
REQUIRE GRANT option
RESTORE TABLE
return (\r)
REVERSE()
REVOKE
RIGHT JOIN
RIGHT OUTER JOIN
RIGHT()
RLIKE
ROLLBACK, ROLLBACK
ROLLBACK TO SAVEPOINT
ROLLUP
ROUND()
rows DBI method
RPAD()
RTRIM()
S
SAVEPOINT
SEC_TO_TIME()
SECOND()
SELECT
SELECT INTO TABLE
SELECT speed
SELECT, optimising
SESSION_USER()
SET, SET, SET
SET OPTION
SET PASSWORD statement
SET TRANSACTION
SHA()
SHA1()
SHOW COLUMNS
SHOW CREATE TABLE, SHOW CREATE TABLE
SHOW DATABASE INFO
SHOW DATABASES
SHOW FIELDS
SHOW GRANTS, SHOW GRANTS
SHOW INDEX
SHOW KEYS
SHOW MASTER LOGS
SHOW MASTER STATUS
SHOW PRIVILEGES
SHOW PROCESSLIST, SHOW PROCESSLIST
SHOW SLAVE STATUS
SHOW STATUS
SHOW TABLE STATUS
SHOW TABLE TYPES, SHOW TABLE TYPES
SHOW TABLES
SHOW VARIABLES
SHOW WARNINGS, SHOW WARNINGS
SIGN()
SIN()
single quote (\')
SMALLINT
SOUNDEX()
SOUNDS LIKE
SPACE()
SQL_CACHE
SQL_NO_CACHE
SQRT()
SRID()
START TRANSACTION
StartPoint()
statements, GRANT
statements, INSERT
STD()
STDDEV()
STRAIGHT_JOIN
STRCMP()
string comparison functions
string functions
SUBDATE()
SUBSTRING(), SUBSTRING()
SUBSTRING_INDEX()
SUBTIME()
subtraction (-)
SUM()
SymDifference()
SYSDATE()
SYSTEM_USER()
T
tab (\t)
table DBI method
Table scan
table_cache
TAN()
TEXT, TEXT
threads
TIME, TIME
TIME()
TIME_FORMAT()
TIME_TO_SEC()
TIMEDIFF()
TIMESTAMP, TIMESTAMP
TIMESTAMP()
TINYBLOB
TINYINT
TINYTEXT
TMPDIR environment variable, TMPDIR environment variable
TO_DAYS()
Touches()
trace DBI method, trace DBI method
TRIM()
TRUE
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 (-)
UNCOMPRESS()
UNCOMPRESSED_LENGTH()
UNION, UNION
Union()
UNIQUE
UNIX_TIMESTAMP()
UNLOCK TABLES
UPDATE
UPPER()
USE
USE INDEX, USE INDEX
USE KEY, USE KEY
USER
environment variable
USER environment variable
USER()
User-defined functions
UTC_DATE()
UTC_TIME()
UTC_TIMESTAMP()
V
VARCHAR, VARCHAR
VARCHARACTER
VARIANCE()
VERSION()
W
WEEK()
WEEKDAY()
WEEKOFYEAR()
WHERE
Wildcard character (%)
Wildcard character (_)
Within()
without-server option
X
X()
XOR, bitwise
XOR, logical
Y
Y()
YEAR, YEAR
YEAR()
| (bitwise OR)
|| (logical OR)
~
Go to the first, previous, next, last section, table of contents.