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)
--password option
-p option
.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 (linefeed)
\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
ALL
ALTER COLUMN
ALTER DATABASE
ALTER FUNCTION
ALTER PROCEDURE
ALTER SCHEMA
ALTER TABLE, ALTER TABLE, ALTER TABLE
ALTER VIEW
ANALYZE TABLE
AND, bitwise
AND, logical
Area(), Area()
arithmetic functions
AS, AS
AsBinary()
ASCII()
ASIN()
AsText()
ATAN()
ATAN2()
AVG()
AVG(DISTINCT)
B
backspace (\b)
BACKUP TABLE
BdMPolyFromText()
BdMPolyFromWKB()
BdPolyFromText()
BdPolyFromWKB()
BEGIN, BEGIN
BENCHMARK()
BETWEEN ... AND
BIGINT data type
BIN()
BINARY
BINARY data type, BINARY data type
BIT data type
BIT_AND()
BIT_COUNT
BIT_COUNT()
BIT_LENGTH()
BIT_OR
BIT_OR()
BIT_XOR()
BLOB data type, BLOB data type
BOOL data type
BOOLEAN data type
Boundary()
Buffer()
C
C:\my.cnf file
CACHE INDEX
CALL
carriage return (\r)
CASE, CASE
CAST
casts
CC
environment variable
CC environment variable, CC environment variable, CC environment variable
CEILING()
Centroid()
CFLAGS environment variable, CFLAGS environment variable, CFLAGS environment variable
CHANGE MASTER TO
CHAR data type, CHAR data type
CHAR VARYING data type
CHAR()
CHAR_LENGTH()
CHARACTER data type
CHARACTER VARYING data type
CHARACTER_LENGTH()
CHARACTER_SETS, INFORMATION_SCHEMA table
CHARSET()
CHECK TABLE
CHECKSUM TABLE
CLOSE
COALESCE()
COERCIBILITY()
COLLATION()
COLLATION_CHARACTER_SET_APPLICABILITY, INFORMATION_SCHEMA table
COLLATIONS, INFORMATION_SCHEMA table
COLUMN_PRIVILEGES, INFORMATION_SCHEMA table
COLUMNS, INFORMATION_SCHEMA table
command-line options
Comment syntax
COMMIT, COMMIT
comparison operators
COMPRESS()
CONCAT()
CONCAT_WS()
configure option, --with-charset
configure option, --with-collation
configure option, --with-extra-charsets
CONNECTION_ID()
constraints
CONSTRAINTS, INFORMATION_SCHEMA table
Contains()
control flow functions
CONV()
CONVERT
CONVERT TO
CONVERT_TZ()
ConvexHull()
COS()
COT()
COUNT()
COUNT(DISTINCT)
CR_SERVER_GONE_ERROR
CR_SERVER_LOST_ERROR
CRC32()
CREATE DATABASE
CREATE FUNCTION, CREATE FUNCTION
CREATE INDEX
CREATE PROCEDURE
CREATE SCHEMA
CREATE TABLE
CREATE USER
CREATE VIEW
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, CXX environment variable, CXX environment variable
CXXFLAGS environment variable, CXXFLAGS environment variable, CXXFLAGS environment variable
D
data type, BIGINT
data type, BINARY, data type, BINARY
data type, BIT
data type, BLOB, data type, BLOB
data type, BOOL, data type, BOOL
data type, BOOLEAN, data type, BOOLEAN
data type, CHAR, data type, CHAR
data type, CHAR VARYING
data type, CHARACTER
data type, CHARACTER VARYING
data type, DATE, data type, DATE
data type, DATETIME, data type, DATETIME
data type, DEC
data type, DECIMAL
data type, DOUBLE
data type, DOUBLE PRECISION
data type, ENUM, data type, ENUM
data type, FIXED
data type, FLOAT, data type, FLOAT, data type, FLOAT
data type, GEOMETRY
data type, GEOMETRYCOLLECTION
data type, INT
data type, INTEGER
data type, LINESTRING
data type, LONG
data type, LONGBLOB
data type, LONGTEXT
data type, MEDIUMBLOB
data type, MEDIUMINT
data type, MEDIUMTEXT
data type, MULTILINESTRING
data type, MULTIPOINT
data type, MULTIPOLYGON
data type, NATIONAL CHAR
data type, NCHAR
data type, NUMERIC
data type, POINT
data type, POLYGON
data type, REAL
data type, SET, data type, SET
data type, SMALLINT
data type, TEXT, data type, TEXT
data type, TIME, data type, TIME
data type, TIMESTAMP, data type, TIMESTAMP
data type, TINYBLOB
data type, TINYINT
data type, TINYTEXT
data type, VARBINARY, data type, VARBINARY
data type, VARCHAR, data type, VARCHAR
data type, VARCHARACTER
data type, YEAR, data type, YEAR
Database information, obtaining
DATABASE()
DATE
date and time functions
DATE data type, DATE data type
DATE()
DATE_ADD()
DATE_FORMAT()
DATE_SUB()
DATEDIFF()
DATETIME data type, DATETIME data type
DAY()
DAYNAME()
DAYOFMONTH()
DAYOFWEEK()
DAYOFYEAR()
DBI->quote
DBI->trace
DBI_TRACE environment variable, DBI_TRACE environment variable
DBI_USER environment variable
DEALLOCATE PREPARE
DEC data type
DECIMAL data type
DECLARE
DECODE()
DEFAULT value clause
DEFAULT()
DEGREES()
DELAYED
DELETE
DES_DECRYPT()
DES_ENCRYPT()
DESC
DESCRIBE, DESCRIBE
Difference()
Dimension()
DISCARD TABLESPACE, DISCARD TABLESPACE
Disjoint()
Distance()
DISTINCT, DISTINCT, DISTINCT, DISTINCT, DISTINCT, DISTINCT, DISTINCT
DISTINCTROW
DIV
division (/)
DO
DOUBLE data type
DOUBLE PRECISION data type
double quote (\")
DROP DATABASE
DROP FOREIGN KEY, DROP FOREIGN KEY
DROP FUNCTION, DROP FUNCTION
DROP INDEX, DROP INDEX
DROP PRIMARY KEY
DROP PROCEDURE
DROP SCHEMA
DROP TABLE
DROP USER
DROP VIEW
DUMPFILE
E
ELT()
ENCODE()
ENCRYPT()
encryption functions
END
EndPoint()
ENUM data type, ENUM data type
Envelope()
environment variable, CC, environment variable, CC
environment variable, CC
Environment variable, CC
environment variable, CFLAGS, environment variable, CFLAGS
Environment variable, CFLAGS
environment variable, CXX
Environment variable, CXX, Environment variable, CXX
environment variable, CXX, environment variable, CXX
environment variable, CXXFLAGS, environment variable, CXXFLAGS
Environment variable, CXXFLAGS
Environment variable, DBI_TRACE, Environment variable, DBI_TRACE
Environment variable, DBI_USER
environment variable, HOME
Environment variable, HOME
Environment variable, LD_LIBRARY_PATH
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
EXP()
EXPLAIN
EXPORT_SET()
ExteriorRing()
EXTRACT()
F
FALSE
FETCH
FIELD()
FILE
FIND_IN_SET()
FIXED data type
FLOAT data type, FLOAT data type, FLOAT data type
FLOOR()
FLUSH
FOR UPDATE
FORCE INDEX, FORCE INDEX, FORCE INDEX
FORCE KEY, FORCE KEY
FORMAT()
FOUND_ROWS()
FROM
FROM_DAYS()
FROM_UNIXTIME()
functions, arithmetic
functions, bit
functions, control flow
functions, date and time
functions, encryption
functions, GROUP BY
functions, information
functions, mathematical
functions, miscellaneous
functions, string
functions, string comparison
Functions, user-defined
G
GeomCollFromText()
GeomCollFromWKB()
GEOMETRY data type
GEOMETRYCOLLECTION data type
GeometryCollection()
GeometryCollectionFromText()
GeometryCollectionFromWKB()
GeometryFromText()
GeometryFromWKB()
GeometryN()
GeometryType()
GeomFromText(), GeomFromText()
GeomFromWKB(), GeomFromWKB()
GET_FORMAT()
GET_LOCK()
GLength(), GLength()
GRANT
GRANT statement, GRANT statement
GRANTS
greater than (>)
greater than or equal (>=)
GREATEST()
GROUP BY
GROUP BY functions
GROUP_CONCAT()
H
HANDLER
HAVING
HEX()
hexadecimal values
HIGH_PRIORITY
HOME environment variable
HOME
environment variable
host.frm, problems finding
HOUR()
I
identifiers, quoting
IF
IF()
IFNULL()
IGNORE INDEX, IGNORE INDEX
IGNORE KEY, IGNORE KEY
IMPORT TABLESPACE, IMPORT TABLESPACE
IN
INET_ATON()
INET_NTOA()
information functions
INFORMATION_SCHEMA, INFORMATION_SCHEMA
INNER JOIN
INSERT, INSERT
INSERT ... SELECT
INSERT DELAYED
INSERT statement, grant privileges
INSERT()
INSTR()
INT data type
INTEGER data type
InteriorRingN()
Intersection()
Intersects()
INTERVAL()
IS boolean_value
IS NOT boolean_value
IS NOT NULL
IS NULL, IS NULL
IS NULL, and indexes
IS_FREE_LOCK()
IS_USED_LOCK()
IsClosed(), IsClosed()
IsEmpty()
ISNULL()
ISOLATION LEVEL
IsRing()
IsSimple()
ITERATE
J
JOIN
K
KEY_COLUMN_USAGE, INFORMATION_SCHEMA table
KILL
L
LAST_DAY()
LAST_INSERT_ID(), LAST_INSERT_ID()
LAST_INSERT_ID([expr])
LCASE()
LD_LIBRARY_PATH environment variable
LD_RUN_PATH environment variable, LD_RUN_PATH environment variable, LD_RUN_PATH environment variable, LD_RUN_PATH environment variable
LEAST()
LEAVE
LEFT JOIN, LEFT JOIN
LEFT OUTER JOIN
LEFT()
LENGTH()
less than (<)
less than or equal (<=)
LIKE
LIKE, and indexes
LIKE, and wildcards
LIMIT, LIMIT, LIMIT
linefeed (\n)
LineFromText()
LineFromWKB()
LINESTRING data type
LineString()
LineStringFromText()
LineStringFromWKB()
LN()
LOAD DATA FROM MASTER
LOAD DATA INFILE, LOAD DATA INFILE
LOAD TABLE FROM MASTER
LOAD_FILE()
LOCALTIME
LOCALTIMESTAMP
LOCATE()
LOCK IN SHARE MODE
LOCK TABLES
LOG()
LOG10()
LOG2()
logical operators
LONG data type
LONGBLOB data type
LONGTEXT data type
LOOP
LOWER()
LPAD()
LTRIM()
M
MAKE_SET()
MAKEDATE()
MAKETIME()
MASTER_POS_WAIT(), MASTER_POS_WAIT()
MATCH ... AGAINST()
mathematical functions
MAX()
MAX(DISTINCT)
MAX_CONNECTIONS_PER_HOUR
MAX_QUERIES_PER_HOUR
MAX_UPDATES_PER_HOUR
MAX_USER_CONNECTIONS
MBRContains()
MBRDisjoint()
MBREqual()
MBRIntersects()
MBROverlaps()
MBRTouches()
MBRWithin()
MD5()
MEDIUMBLOB data type
MEDIUMINT data type
MEDIUMTEXT data type
MICROSECOND()
MID()
MIN()
MIN(DISTINCT)
minus, unary (-)
MINUTE()
miscellaneous functions
MLineFromText()
MLineFromWKB()
MOD (modulo)
MOD()
modulo (%)
modulo (MOD)
MONTH()
MONTHNAME()
MPointFromText()
MPointFromWKB()
MPolyFromText()
MPolyFromWKB()
MULTILINESTRING data type
MultiLineString()
MultiLineStringFromText()
MultiLineStringFromWKB()
multiplication (*)
MULTIPOINT data type
MultiPoint()
MultiPointFromText()
MultiPointFromWKB()
MULTIPOLYGON data type
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_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_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_client_version()
mysql_get_host_info()
mysql_get_proto_info()
mysql_get_server_info()
mysql_get_server_version()
mysql_hex_string()
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_insert_id()
mysql_kill()
mysql_library_end()
mysql_library_init()
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_ping()
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_server_end()
mysql_server_init()
mysql_set_sever_option()
mysql_shutdown()
mysql_sqlstate()
mysql_ssl_set()
mysql_stat()
MYSQL_STMT C type
mysql_stmt_affected_rows()
mysql_stmt_attr_get()
mysql_stmt_attr_set()
mysql_stmt_bind_param()
mysql_stmt_bind_result()
mysql_stmt_close()
mysql_stmt_data_seek()
mysql_stmt_errno()
mysql_stmt_error()
.
mysql_stmt_execute()
mysql_stmt_fetch()
mysql_stmt_fetch_column()
mysql_stmt_field_count()
mysql_stmt_free_result()
mysql_stmt_init()
mysql_stmt_insert_id()
mysql_stmt_num_rows()
mysql_stmt_param_count()
mysql_stmt_param_metadata()
mysql_stmt_prepare()
mysql_stmt_reset()
mysql_stmt_result_metadata
.
mysql_stmt_row_seek()
mysql_stmt_row_tell()
mysql_stmt_send_long_data()
.
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()
mysql_warning_count()
.
N
NATIONAL CHAR data type
NATURAL LEFT JOIN
NATURAL LEFT OUTER JOIN
NATURAL RIGHT JOIN
NATURAL RIGHT OUTER JOIN
NCHAR data type
newline (\n)
NOT BETWEEN
not equal (!=)
not equal (<>)
NOT IN
NOT LIKE
NOT REGEXP
NOT, logical
NOW()
NUL
NULL, NULL
NULL value
NULLIF()
NUMERIC data type
NumGeometries()
NumInteriorRings()
NumPoints()
O
OCT()
OCTET_LENGTH()
OLAP
OLD_PASSWORD()
OPEN
operators, logical
OPTIMIZE TABLE
OR, OR
OR, bitwise
OR, logical
ORD()
ORDER BY, ORDER BY, ORDER BY
OUTFILE
Overlaps()
P
parentheses ( and )
PASSWORD(), PASSWORD(), PASSWORD(), PASSWORD()
PATH environment variable, PATH environment variable
PERIOD_ADD()
PERIOD_DIFF()
PI()
POINT data type
Point()
PointFromText()
PointFromWKB()
PointN()
PointOnSurface()
PolyFromText()
PolyFromWKB()
POLYGON data type
Polygon()
PolygonFromText()
PolygonFromWKB()
POSITION()
POW()
POWER()
PREPARE
PRIMARY KEY, PRIMARY KEY
PROCEDURE
PROCESSLIST
PURGE MASTER LOGS
Q
QUARTER()
QUOTE()
quoting of identifiers
R
RADIANS()
RAND()
REAL data type
ref_or_null
REGEXP
Related()
RELEASE_LOCK()
RENAME TABLE
RENAME USER
REPAIR TABLE
REPEAT
REPEAT()
REPLACE
REPLACE ... SELECT
REPLACE()
REQUIRE GRANT option, REQUIRE GRANT option
RESET MASTER
RESET SLAVE
RESTORE TABLE
return (\r)
REVERSE()
REVOKE
RIGHT JOIN
RIGHT OUTER JOIN
RIGHT()
RLIKE
ROLLBACK, ROLLBACK
ROLLBACK TO SAVEPOINT
ROLLUP
ROUND()
ROUTINES, INFORMATION_SCHEMA table
ROW_COUNT()
RPAD()
RTRIM()
S
SAVEPOINT
SCHEMA_PRIVILEGES, INFORMATION_SCHEMA table
SCHEMATA, INFORMATION_SCHEMA table
SEC_TO_TIME()
SECOND()
SELECT INTO
SELECT INTO TABLE
SELECT speed
SELECT, LIMIT
SELECT, optimizing
SESSION_USER()
SET, SET
SET data type, SET data type
SET GLOBAL SQL_SLAVE_SKIP_COUNTER
SET OPTION
SET PASSWORD
SET PASSWORD statement
SET SQL_LOG_BIN
SET TRANSACTION
SHA()
SHA1()
SHOW BINARY LOGS
SHOW BINLOG EVENTS, SHOW BINLOG EVENTS
SHOW CHARACTER SET
SHOW COLLATION
SHOW COLUMNS, SHOW COLUMNS
SHOW CREATE DATABASE, SHOW CREATE DATABASE
SHOW CREATE FUNCTION
SHOW CREATE PROCEDURE
SHOW CREATE SCHEMA, SHOW CREATE SCHEMA
SHOW CREATE TABLE, SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW DATABASES, SHOW DATABASES
SHOW ENGINES, SHOW ENGINES
SHOW ERRORS, SHOW ERRORS
SHOW extensions
SHOW FIELDS
SHOW FUNCTION STATUS
SHOW GRANTS, SHOW GRANTS
SHOW INDEX, SHOW INDEX
SHOW INNODB STATUS
SHOW KEYS, SHOW KEYS
SHOW MASTER LOGS, SHOW MASTER LOGS
SHOW MASTER STATUS, SHOW MASTER STATUS
SHOW PRIVILEGES, SHOW PRIVILEGES
SHOW PROCEDURE STATUS
SHOW PROCESSLIST, SHOW PROCESSLIST
SHOW SCHEMAS, SHOW SCHEMAS
SHOW SLAVE HOSTS, SHOW SLAVE HOSTS
SHOW SLAVE STATUS, SHOW SLAVE STATUS
SHOW STATUS
SHOW STORAGE ENGINES
SHOW TABLE STATUS
SHOW TABLE TYPES, SHOW TABLE TYPES
SHOW TABLES, SHOW TABLES
SHOW VARIABLES
SHOW WARNINGS, SHOW WARNINGS
SHOW with WHERE, SHOW with WHERE
SIGN()
SIN()
single quote (\')
SMALLINT data type
SOUNDEX()
SOUNDS LIKE
SPACE()
SQL_BIG_RESULT
SQL_BUFFER_RESULT
SQL_CACHE, SQL_CACHE
SQL_CALC_FOUND_ROWS
SQL_NO_CACHE, SQL_NO_CACHE
SQL_SMALL_RESULT
SQRT()
SRID()
START SLAVE
START TRANSACTION
StartPoint()
statements, GRANT
statements, INSERT
STATISTICS, INFORMATION_SCHEMA table
STD()
STDDEV()
STDDEV_POP()
STDDEV_SAMP()
STOP SLAVE
STR_TO_DATE()
STRAIGHT_JOIN, STRAIGHT_JOIN
STRCMP()
string comparison functions
string functions
SUBDATE()
SUBSTRING()
SUBSTRING_INDEX()
SUBTIME()
subtraction (-)
SUM()
SUM(DISTINCT)
SymDifference()
SYSDATE()
SYSTEM_USER()
T
tab (\t)
table_cache
TABLE_PRIVILEGES, INFORMATION_SCHEMA table
TABLES, INFORMATION_SCHEMA table
TAN()
TEXT data type, TEXT data type
threads
TIME data type, TIME data type
TIME()
TIME_FORMAT()
TIME_TO_SEC()
TIMEDIFF()
TIMESTAMP data type, TIMESTAMP data type
TIMESTAMP()
TIMESTAMPADD()
TIMESTAMPDIFF()
TINYBLOB data type
TINYINT data type
TINYTEXT data type
TMPDIR environment variable, TMPDIR environment variable
TO_DAYS()
Touches()
trace DBI method
TRIM()
TRUE
TRUNCATE
TRUNCATE()
Types
TZ environment variable, TZ environment variable
U
UCASE()
UDFs
ulimit
UMASK environment variable, UMASK environment variable
UMASK_DIR environment variable, UMASK_DIR environment variable
unary minus (-)
UNCOMPRESS()
UNCOMPRESSED_LENGTH()
UNHEX()
Unicode Collation Algorithm
UNION, UNION
Union()
UNIQUE
UNIX_TIMESTAMP()
UNLOCK TABLES
UNTIL
UPDATE
UPPER()
USE
USE INDEX, USE INDEX
USE KEY, USE KEY
USER environment variable
USER
environment variable
USER()
User-defined functions
USER_PRIVILEGES, INFORMATION_SCHEMA table
UTC_DATE()
UTC_TIME()
UTC_TIMESTAMP()
UUID()
V
VAR_POP()
VAR_SAMP()
VARBINARY data type, VARBINARY data type
VARCHAR data type, VARCHAR data type
VARCHARACTER data type
VARIANCE()
VERSION()
VIEWS, INFORMATION_SCHEMA table
W
WEEK()
WEEKDAY()
WEEKOFYEAR()
WHERE
WHERE, with SHOW, WHERE, with SHOW
WHILE
Wildcard character (%)
Wildcard character (_)
with-big-tables option
Within()
without-server option
X
X()
XOR, bitwise
XOR, logical
Y
Y()
YEAR data type, YEAR data type
YEAR()
YEARWEEK()
| (bitwise OR)
|| (logical OR)
~
Go to the first, previous, next, last section, table of contents.