SQL command, type and function index
************************************
See ``Mathematical Functions''.
% (wildcard character):
See ``Strings''.
& (bitwise AND):
See ``Bit Functions''.
&& (logical AND):
See ``Logical Operators''.
() (parentheses):
See ``Parentheses''.
(Control-Z) \z:
See ``Strings''.
* (multiplication):
See ``Arithmetic Operations''.
+ (addition):
See ``Arithmetic Operations''.
- (subtraction):
See ``Arithmetic Operations''.
- (unary minus):
See ``Mathematical Functions''.
-p option:
See ``Keeping Your Password Secure''.
-password option:
See ``Keeping Your Password Secure''.
.my.cnf file <1>:
See ``Keeping Your Password Secure''.
.my.cnf file <2>:
See ``Causes of `Access denied' Errors''.
.my.cnf file <3>:
See ``Connecting to the MySQL Server''.
.my.cnf file <4>:
See ``Using Client Programs in a Multiple-Server Environment''.
.my.cnf file <5>
.pid (process ID) file:
See ``Setting Up a Table Maintenance Regimen''.
/ (division):
See ``Arithmetic Operations''.
/etc/passwd <1>:
See ```SELECT' Syntax''.
/etc/passwd:
See ``How to Make MySQL Secure Against Crackers''.
< (less than):
See ``Comparison Operators''.
<<:
See ``Calculating Visits Per Day''.
<< (left shift):
See ``Bit Functions''.
<= (less than or equal):
See ``Comparison Operators''.
<=> (Equal to):
See ``Comparison Operators''.
<> (not equal):
See ``Comparison Operators''.
= (equal):
See ``Comparison Operators''.
> (greater than):
See ``Comparison Operators''.
>= (greater than or equal):
See ``Comparison Operators''.
>>
See ``Strings''.
\b (backspace):
See ``Strings''.
\n (newline):
See ``Strings''.
\r (carriage return):
See ``Strings''.
\t (tab):
See ``Strings''.
\z (Control-Z) ASCII(26):
See ``Strings''.
^ (bitwise XOR):
See ``Bit Functions''.
_ (wildcard character):
See ``Strings''.
`:
See ``Database, Table, Index, Column, and Alias Names''.
ABS():
See ``Mathematical Functions''.
ACOS():
See ``Mathematical Functions''.
ADDDATE():
See ``Date and Time Functions''.
addition (+):
See ``Arithmetic Operations''.
ADDTIME():
See ``Date and Time Functions''.
AES_DECRYPT():
See ``Miscellaneous Functions''.
AES_ENCRYPT():
See ``Miscellaneous Functions''.
alias:
See ``Problems with `alias'''.
ALTER COLUMN:
See ```ALTER TABLE' Syntax''.
ALTER TABLE <1> Functions''.
AND, logical:
See ``Logical Operators''.
Area() <1>:
See ```MultiPolygon' Property Analysis Functions''.
Area():
See ```Polygon' Property Analysis Functions''.
arithmetic functions:
See ``Bit Functions''.
AS <1>
ASIN():
See ``Mathematical Functions''.
AsText():
See ``Functions to Convert Geometries Between Formats''.
ATAN():
See ``Mathematical Functions''.
ATAN2():
See ``Mathematical Functions''.
AUTO_INCREMENT, using with DBI:
See ``The `DBI' Interface''.
AVG():
See ```GROUP BY' Functions''.
backspace (\b):
See ``Strings''.
BACKUP TABLE:
See ```BACKUP TABLE' Syntax''.
BdMPolyFromText():
See ``Creating Geometry Values Using WKT Functions''.
BdMPolyFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
BdPolyFromText():
See ``Creating Geometry Values Using WKT Functions''.
BdPolyFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
BEGIN:
See ```START TRANSACTION', `COMMIT', and `ROLLBACK' Syntax''.
BENCHMARK():
See ``Miscellaneous Functions''.
BETWEEN ... AND:
See ``Comparison Operators''.
BIGINT:
See ``Column Types''.
BIN():
See ``String Functions''.
BINARY:
See ``Case-Sensitivity''.
BIT:
See ``Column Types''.
BIT_AND():
See ```GROUP BY' Functions''.
BIT_COUNT:
See ``Calculating Visits Per Day''.
BIT_COUNT():
See ``Bit Functions''.
BIT_LENGTH():
See ``String Functions''.
BIT_OR:
See ``Calculating Visits Per Day''.
BIT_OR():
See ```GROUP BY' Functions''.
BIT_XOR():
See ```GROUP BY' Functions''.
BLOB <1> ``General Geometry Property Analysis Functions''.
Buffer():
See ``Spatial Operators''.
C:\my.cnf file:
See ``Using Client Programs in a Multiple-Server Environment''.
carriage return (\r):
See ``Strings''.
CASE:
See ``Control Flow Functions''.
CAST:
See ``Cast Functions''.
casts:
See ``Case-Sensitivity''.
CC environment variable <1>:
See ``Environment Variables''.
CC environment variable <2>
See ``Mathematical Functions''.
Centroid() <1>:
See ```MultiPolygon' Property Analysis Functions''.
Centroid():
See ```Polygon' Property Analysis Functions''.
CFLAGS environment variable <1>:
See ``Environment Variables''.
CFLAGS environment variable:
See ``Problems Compiling MySQL?''.
CHANGE MASTER TO:
See ```CHANGE MASTER TO'''.
CHAR <1> Functions''.
CHARACTER:
See ``Column Types''.
CHARACTER VARYING:
See ``Column Types''.
CHARACTER_LENGTH():
See ``String Functions''.
CHECK TABLE:
See ```CHECK TABLE' Syntax''.
ChopBlanks DBI method:
See ``The `DBI' Interface''.
COALESCE():
See ``Comparison Operators''.
command-line options:
See ```mysqld' Command-line Options''.
Comment syntax:
See ``Comment Syntax''.
COMMIT <1>
COMPRESS():
See ``Miscellaneous Functions''.
CONCAT():
See ``String Functions''.
CONCAT_WS():
See ``String Functions''.
configure option, --with-charset:
See ``Typical `configure' Options''.
configure option, --with-extra-charsets:
See ``Typical `configure' Options''.
connect() DBI method:
See ``The `DBI' Interface''.
CONNECTION_ID():
See ``Miscellaneous Functions''.
constraints:
See ``How MySQL deals with constraints''.
Contains():
See ``Functions That Test Spatial Relationships Between Geometries''.
control flow functions:
See ``Control Flow Functions''.
CONV():
See ``String Functions''.
CONVERT:
See ``Cast Functions''.
ConvexHull():
See ``Spatial Operators''.
COS():
See ``Mathematical Functions''.
COT():
See ``Mathematical Functions''.
COUNT():
See ```GROUP BY' Functions''.
COUNT(DISTINCT):
See ```GROUP BY' Functions''.
CRC32():
See ``Mathematical Functions''.
CREATE DATABASE:
See ```CREATE DATABASE' Syntax''.
CREATE FUNCTION:
See ```CREATE FUNCTION/DROP FUNCTION' Syntax''.
CREATE INDEX:
See ```CREATE INDEX' Syntax''.
CREATE TABLE:
See ```CREATE TABLE' Syntax''.
CROSS JOIN:
See ```JOIN' Syntax''.
Crosses():
See ``Functions That Test Spatial Relationships Between Geometries''.
CURDATE():
See ``Date and Time Functions''.
CURRENT_DATE:
See ``Date and Time Functions''.
CURRENT_TIME:
See ``Date and Time Functions''.
CURRENT_TIMESTAMP:
See ``Date and Time Functions''.
CURRENT_USER():
See ``Miscellaneous Functions''.
CURTIME():
See ``Date and Time Functions''.
CXX environment variable <1>:
See ``Problems Compiling MySQL?''.
CXX environment variable:
See ``Typical `configure' Options''.
CXXFLAGS environment variable <1>:
See ``Environment Variables''.
CXXFLAGS environment variable <2> information, obtaining:
See ```SHOW' Syntax''.
DATABASE():
See ``Miscellaneous Functions''.
DATE <1>:
See ``Problems Using `DATE' Columns''.
DATE <2> ``Date and Time Functions''.
DATE_ADD():
See ``Date and Time Functions''.
DATE_FORMAT():
See ``Date and Time Functions''.
DATE_SUB():
See ``Date and Time Functions''.
DATEDIFF():
See ``Date and Time Functions''.
DATETIME <1>:
See ``The `DATETIME', `DATE', and `TIMESTAMP' Types''.
DATETIME:
See ``Column Types''.
DAY():
See ``Date and Time Functions''.
DAYNAME():
See ``Date and Time Functions''.
DAYOFMONTH():
See ``Date and Time Functions''.
DAYOFWEEK():
See ``Date and Time Functions''.
DAYOFYEAR():
See ``Date and Time Functions''.
DBI->connect():
See ``The `DBI' Interface''.
DBI->data_sources():
See ``The `DBI' Interface''.
DBI->disconnect:
See ``The `DBI' Interface''.
DBI->do():
See ``The `DBI' Interface''.
DBI->execute:
See ``The `DBI' Interface''.
DBI->fetchall_arrayref:
See ``The `DBI' Interface''.
DBI->fetchrow_array:
See ``The `DBI' Interface''.
DBI->fetchrow_arrayref:
See ``The `DBI' Interface''.
DBI->fetchrow_hashref:
See ``The `DBI' Interface''.
DBI->finish:
See ``The `DBI' Interface''.
DBI->prepare():
See ``The `DBI' Interface''.
DBI->quote:
See ``Strings''.
DBI->quote():
See ``The `DBI' Interface''.
DBI->rows:
See ``The `DBI' Interface''.
DBI->trace <1>:
See ``Debugging mysqld under gdb''.
DBI->trace:
See ``The `DBI' Interface''.
DBI->{ChopBlanks}:
See ``The `DBI' Interface''.
DBI->{is_blob}:
See ``The `DBI' Interface''.
DBI->{is_key}:
See ``The `DBI' Interface''.
DBI->{is_not_null}:
See ``The `DBI' Interface''.
DBI->{is_num}:
See ``The `DBI' Interface''.
DBI->{is_pri_key}:
See ``The `DBI' Interface''.
DBI->{length}:
See ``The `DBI' Interface''.
DBI->{max_length}:
See ``The `DBI' Interface''.
DBI->{mysql_insertid}:
See ``The `DBI' Interface''.
DBI->{NAME}:
See ``The `DBI' Interface''.
DBI->{NULLABLE}:
See ``The `DBI' Interface''.
DBI->{NUM_OF_FIELDS}:
See ``The `DBI' Interface''.
DBI->{table}:
See ``The `DBI' Interface''.
DBI->{type}:
See ``The `DBI' Interface''.
DBI_TRACE environment variable <1>:
See ``Environment Variables''.
DBI_TRACE environment variable <2>
See ``Column Types''.
DECIMAL:
See ``Column Types''.
DECODE():
See ``Miscellaneous Functions''.
DEGREES():
See ``Mathematical Functions''.
DELAYED:
See ```INSERT DELAYED' Syntax''.
DELETE:
See ```DELETE' Syntax''.
DES_DECRYPT():
See ``Miscellaneous Functions''.
DES_ENCRYPT():
See ``Miscellaneous Functions''.
DESC:
See ```DESCRIBE' Syntax (Get Information About Columns)''.
DESCRIBE <1>:
See ```DESCRIBE' Syntax (Get Information About Columns)''.
DESCRIBE:
See ``Getting Information About Databases and Tables''.
Difference():
See ``Spatial Operators''.
Dimension():
See ``General Geometry Property Analysis Functions''.
disconnect DBI method:
See ``The `DBI' Interface''.
Disjoint():
See ``Functions That Test Spatial Relationships Between Geometries''.
Distance():
See ``Functions That Test Spatial Relationships Between Geometries''.
DISTINCT <1>:
See ```GROUP BY' Functions''.
DISTINCT <2>:
See ``How MySQL Optimises `DISTINCT'''.
DISTINCT:
See ``Selecting Particular Columns''.
DIV:
See ``Mathematical Functions''.
division (/):
See ``Arithmetic Operations''.
DO:
See ```DO' Syntax''.
do() DBI method:
See ``The `DBI' Interface''.
DOUBLE:
See ``Column Types''.
DOUBLE PRECISION:
See ``Column Types''.
double quote (\"):
See ``Strings''.
DROP DATABASE:
See ```DROP DATABASE' Syntax''.
DROP FUNCTION:
See ```CREATE FUNCTION/DROP FUNCTION' Syntax''.
DROP INDEX <1>:
See ```DROP INDEX' Syntax''.
DROP INDEX:
See ```ALTER TABLE' Syntax''.
DROP PRIMARY KEY:
See ```ALTER TABLE' Syntax''.
DROP TABLE:
See ```DROP TABLE' Syntax''.
DROP USER:
See ``Deleting Users from MySQL''.
DUMPFILE:
See ```SELECT' Syntax''.
ELT():
See ``String Functions''.
ENCODE():
See ``Miscellaneous Functions''.
ENCRYPT():
See ``Miscellaneous Functions''.
EndPoint():
See ```LineString' Property Analysis Functions''.
ENUM <1>:
See ``The `ENUM' Type''.
ENUM:
See ``Column Types''.
Envelope():
See ``General Geometry Property Analysis Functions''.
Environment variable, CC:
See ``Environment Variables''.
environment variable, CC <1>:
See ``Problems Compiling MySQL?''.
environment variable, CC:
See ``Typical `configure' Options''.
Environment variable, CCX:
See ``Environment Variables''.
Environment variable, CFLAGS:
See ``Environment Variables''.
environment variable, CFLAGS:
See ``Problems Compiling MySQL?''.
environment variable, CXX:
See ``Problems Compiling MySQL?''.
Environment variable, CXX:
See ``Problems Compiling MySQL?''.
environment variable, CXX:
See ``Typical `configure' Options''.
Environment variable, CXXFLAGS:
See ``Environment Variables''.
environment variable, CXXFLAGS <1>:
See ``Problems Compiling MySQL?''.
environment variable, CXXFLAGS:
See ``Typical `configure' Options''.
Environment variable, DBI_TRACE <1> variable, DBI_USER:
See ``Environment Variables''.
Environment variable, HOME:
See ``Environment Variables''.
environment variable, HOME:
See ``Overview of the Client-Side Scripts and Utilities''.
Environment variable, LD_RUN_PATH <1>:
See ``Environment Variables''.
Environment variable, LD_RUN_PATH <2>:
See ``Problems Using the Perl `DBI'/`DBD' Interface''.
Environment variable, LD_RUN_PATH:
See ``Solaris Notes''.
environment variable, LD_RUN_PATH:
See ``Linux Notes (All Linux Versions)''.
Environment variable, MYSQL_DEBUG <1>:
See ``Environment Variables''.
Environment variable, MYSQL_DEBUG:
See ``Debugging a MySQL client''.
environment variable, MYSQL_DEBUG:
See ``Overview of the Client-Side Scripts and Utilities''.
Environment variable, MYSQL_HISTFILE:
See ``Environment Variables''.
environment variable, MYSQL_HISTFILE:
See ``Overview of the Client-Side Scripts and Utilities''.
Environment variable, MYSQL_HOST:
See ``Environment Variables''.
environment variable, MYSQL_HOST:
See ``Connecting to the MySQL Server''.
Environment variable, MYSQL_PS1:
See ``Environment Variables''.
Environment variable, MYSQL_PWD:
See ``Environment Variables''.
environment variable, MYSQL_PWD <1> See ``Environment Variables''.
environment variable, MYSQL_TCP_PORT <1>:
See ``Overview of the Client-Side Scripts and Utilities''.
environment variable, MYSQL_TCP_PORT <2>:
See ``Using Client Programs in a Multiple-Server Environment''.
environment variable, MYSQL_TCP_PORT:
See ``Running Multiple Servers on Unix''.
Environment variable, MYSQL_UNIX_PORT:
See ``Environment Variables''.
environment variable, MYSQL_UNIX_PORT <1>:
See ``Overview of the Client-Side Scripts and Utilities''.
environment variable, MYSQL_UNIX_PORT <2>
See ``Problems Running `mysql_install_db'''.
Environment variable, PATH:
See ``Environment Variables''.
environment variable, PATH:
See ``Installing a MySQL Binary Distribution''.
Environment variable, TMPDIR <1>:
See ``Environment Variables''.
Environment variable, TMPDIR:
See ``Problems Running `mysql_install_db'''.
Environment variable, TZ <1>:
See ``Environment Variables''.
Environment variable, TZ:
See ``Time Zone Problems''.
Environment variable, UMASK <1>:
See ``Environment Variables''.
Environment variable, UMASK:
See ``Problems with File Permissions''.
Environment variable, UMASK_DIR <1>
environment variable, USER:
See ``Connecting to the MySQL Server''.
Environment variables, CXX:
See ``Problems Compiling MySQL?''.
equal (=):
See ``Comparison Operators''.
Equals():
See ``Functions That Test Spatial Relationships Between Geometries''.
escape (\\):
See ``Strings''.
execute DBI method:
See ``The `DBI' Interface''.
EXP():
See ``Mathematical Functions''.
EXPLAIN:
See ```EXPLAIN' Syntax (Get Information About a `SELECT')''.
EXPORT_SET():
See ``String Functions''.
ExteriorRing():
See ```Polygon' Property Analysis Functions''.
EXTRACT():
See ``Date and Time Functions''.
FALSE:
See ``Numbers''.
fetchall_arrayref DBI method:
See ``The `DBI' Interface''.
fetchrow_array DBI method:
See ``The `DBI' Interface''.
fetchrow_arrayref DBI method:
See ``The `DBI' Interface''.
fetchrow_hashref DBI method:
See ``The `DBI' Interface''.
FIELD():
See ``String Functions''.
FILE:
See ``String Functions''.
FIND_IN_SET():
See ``String Functions''.
finish DBI method:
See ``The `DBI' Interface''.
FIXED:
See ``Column Types''.
FLOAT:
See ``Column Types''.
FLOAT(M,D):
See ``Column Types''.
FLOAT(precision):
See ``Column Types''.
FLOOR():
See ``Mathematical Functions''.
FLUSH:
See ```FLUSH' Syntax''.
FORCE INDEX <1>:
See ```JOIN' Syntax''.
FORCE INDEX:
See ```SELECT' Syntax''.
FORMAT():
See ``Miscellaneous Functions''.
FOUND_ROWS():
See ``Miscellaneous Functions''.
FROM:
See ```SELECT' Syntax''.
FROM_DAYS():
See ``Date and Time Functions''.
FROM_UNIXTIME():
See ``Date and Time Functions''.
functions, arithmetic:
See ``Bit Functions''.
functions, bit:
See ``Bit Functions''.
functions, control flow:
See ``Control Flow Functions''.
functions, date and time:
See ``Date and Time Functions''.
functions, GROUP BY:
See ```GROUP BY' Functions''.
functions, mathematical:
See ``Mathematical Functions''.
functions, miscellaneous:
See ``Miscellaneous Functions''.
functions, string:
See ``String Functions''.
functions, string comparison:
See ``String Comparison Functions''.
Functions, user-defined:
See ```CREATE FUNCTION/DROP FUNCTION' Syntax''.
GeomCollFromText():
See ``Creating Geometry Values Using WKT Functions''.
GeomCollFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
GEOMETRY:
See ``MySQL Spatial Datatypes''.
GEOMETRYCOLLECTION:
See ``MySQL Spatial Datatypes''.
GeometryCollection():
See ``Creating Geometry Values Using MySQL-Specific Functions''.
GeometryCollectionFromText():
See ``Creating Geometry Values Using WKT Functions''.
GeometryCollectionFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
GeometryFromText():
See ``Creating Geometry Values Using WKT Functions''.
GeometryFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
GeometryN():
See ```GeometryCollection' Property Analysis Functions''.
GeometryType():
See ``General Geometry Property Analysis Functions''.
GeomFromText() <1>:
See ``Functions to Convert Geometries Between Formats''.
GeomFromText():
See ``Creating Geometry Values Using WKT Functions''.
GeomFromWKB() <1>
GLength() <1> statement <1>:
See ``SSL `GRANT' Options''.
GRANT statement:
See ``Adding New Users to MySQL''.
GRANTS:
See ```SHOW GRANTS'''.
greater than (>):
See ``Comparison Operators''.
greater than or equal (>=):
See ``Comparison Operators''.
GREATEST():
See ``Mathematical Functions''.
GROUP BY functions:
See ```GROUP BY' Functions''.
GROUP_CONCAT():
See ```GROUP BY' Functions''.
HANDLER:
See ```UNION' Syntax''.
HEX():
See ``String Functions''.
hexadecimal values:
See ``Hexadecimal Values''.
HOME environment variable <1>:
See ``Environment Variables''.
HOME environment variable:
See ``Overview of the Client-Side Scripts and Utilities''.
host.frm, problems finding:
See ``Post-installation Setup and Testing''.
HOUR():
See ``Date and Time Functions''.
identifiers, quoting:
See ``Database, Table, Index, Column, and Alias Names''.
IF():
See ``Control Flow Functions''.
IFNULL():
See ``Control Flow Functions''.
IGNORE INDEX <1>:
See ```JOIN' Syntax''.
IGNORE INDEX:
See ```SELECT' Syntax''.
IGNORE KEY <1>
See ``Miscellaneous Functions''.
INNER JOIN:
See ```JOIN' Syntax''.
INSERT <1>:
See ```INSERT' Syntax''.
INSERT:
See ``Speed of `INSERT' Queries''.
INSERT ... SELECT:
See ```INSERT' Syntax''.
INSERT DELAYED:
See ```INSERT DELAYED' Syntax''.
INSERT statement, grant privileges:
See ``Adding New Users to MySQL''.
INSERT():
See ``String Functions''.
INSTR():
See ``String Functions''.
INT:
See ``Column Types''.
INTEGER:
See ``Column Types''.
InteriorRingN():
See ```Polygon' Property Analysis Functions''.
Intersection():
See ``Spatial Operators''.
Intersects():
See ``Functions That Test Spatial Relationships Between Geometries''.
INTERVAL():
See ``Comparison Operators''.
IS NOT NULL:
See ``Comparison Operators''.
IS NULL <1>:
See ``Comparison Operators''.
IS NULL:
See ``How MySQL Optimises `IS NULL'''.
IS NULL, and indexes:
See ``How MySQL Uses Indexes''.
is_blob DBI method:
See ``The `DBI' Interface''.
IS_FREE_LOCK():
See ``Miscellaneous Functions''.
is_key DBI method:
See ``The `DBI' Interface''.
is_not_null DBI method:
See ``The `DBI' Interface''.
is_num DBI method:
See ``The `DBI' Interface''.
is_pri_key DBI method:
See ``The `DBI' Interface''.
IsClosed() <1>:
See ```MultiLineString' Property Analysis Functions''.
IsClosed():
See ```LineString' Property Analysis Functions''.
IsEmpty():
See ``General Geometry Property Analysis Functions''.
ISNULL():
See ``Comparison Operators''.
ISOLATION LEVEL:
See ```SET TRANSACTION' Syntax''.
IsRing():
See ```LineString' Property Analysis Functions''.
IsSimple():
See ``General Geometry Property Analysis Functions''.
JOIN:
See ```JOIN' Syntax''.
KILL:
See ```KILL' Syntax''.
LAST_INSERT_ID():
See ``Transactions and Atomic Operations''.
LAST_INSERT_ID([expr]):
See ``Miscellaneous Functions''.
LCASE():
See ``String Functions''.
LD_RUN_PATH environment variable <1>:
See ``Environment Variables''.
LD_RUN_PATH environment variable <2>:
See ``Problems Using the Perl `DBI'/`DBD' Interface''.
LD_RUN_PATH environment variable <3>:
See ``Solaris Notes''.
LD_RUN_PATH environment variable:
See ``Linux Notes (All Linux Versions)''.
LEAST():
See ``Mathematical Functions''.
LEFT JOIN <1> Functions''.
length DBI method:
See ``The `DBI' Interface''.
LENGTH():
See ``String Functions''.
less than (<):
See ``Comparison Operators''.
less than or equal (<=):
See ``Comparison Operators''.
LIKE:
See ``String Comparison Functions''.
LIKE, and indexes:
See ``How MySQL Uses Indexes''.
LIKE, and wildcards:
See ``How MySQL Uses Indexes''.
LIMIT <1>
See ``Creating Geometry Values Using WKB Functions''.
LINESTRING:
See ``MySQL Spatial Datatypes''.
LineString():
See ``Creating Geometry Values Using MySQL-Specific Functions''.
LineStringFromText():
See ``Creating Geometry Values Using WKT Functions''.
LineStringFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
LN():
See ``Mathematical Functions''.
LOAD DATA FROM MASTER:
See ```LOAD DATA FROM MASTER'''.
LOAD DATA INFILE <1>
See ``String Functions''.
LOCALTIME:
See ``Date and Time Functions''.
LOCALTIMESTAMP:
See ``Date and Time Functions''.
LOCATE():
See ``String Functions''.
LOCK TABLES:
See ```LOCK TABLES' and `UNLOCK TABLES' Syntax''.
LOG():
See ``Mathematical Functions''.
LOG10():
See ``Mathematical Functions''.
LOG2():
See ``Mathematical Functions''.
Logical operators:
See ``Logical Operators''.
LONG:
See ``The `BLOB' and `TEXT' Types''.
LONGBLOB:
See ``Column Types''.
LONGTEXT:
See ``Column Types''.
LOWER():
See ``String Functions''.
LPAD():
See ``String Functions''.
LTRIM():
See ``String Functions''.
MAKE_SET():
See ``String Functions''.
MAKEDATE():
See ``Date and Time Functions''.
MAKETIME():
See ``Date and Time Functions''.
MASTER_POS_WAIT() <1>:
See ``Miscellaneous Functions''.
MASTER_POS_WAIT():
See ```MASTER_POS_WAIT()'''.
MATCH ... AGAINST():
See ``String Comparison Functions''.
mathematical functions:
See ``Mathematical Functions''.
MAX():
See ```GROUP BY' Functions''.
max_length DBI method:
See ``The `DBI' Interface''.
MBRContains():
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
MBRDisjoint():
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
MBREquals():
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
MBRIntersects():
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
MBROverlaps():
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
MBRTouches():
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
MBRWithin():
See ``Relations On Geometry Minimal Bounding Rectangles (MBRs)''.
MD5():
See ``Miscellaneous Functions''.
MEDIUMBLOB:
See ``Column Types''.
MEDIUMINT:
See ``Column Types''.
MEDIUMTEXT:
See ``Column Types''.
MICROSECOND():
See ``Date and Time Functions''.
MID():
See ``String Functions''.
MIN():
See ```GROUP BY' Functions''.
minus, unary (-):
See ``Mathematical Functions''.
MINUTE():
See ``Date and Time Functions''.
miscellaneous functions:
See ``Miscellaneous Functions''.
MLineFromText():
See ``Creating Geometry Values Using WKT Functions''.
MLineFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
MOD (modulo):
See ``Mathematical Functions''.
MOD():
See ``Mathematical Functions''.
modulo (%):
See ``Mathematical Functions''.
modulo (MOD):
See ``Mathematical Functions''.
MONTH():
See ``Date and Time Functions''.
MONTHNAME():
See ``Date and Time Functions''.
MPointFromText():
See ``Creating Geometry Values Using WKT Functions''.
MPointFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
MPolyFromText():
See ``Creating Geometry Values Using WKT Functions''.
MPolyFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
MULTILINESTRING:
See ``MySQL Spatial Datatypes''.
MultiLineString():
See ``Creating Geometry Values Using MySQL-Specific Functions''.
MultiLineStringFromText():
See ``Creating Geometry Values Using WKT Functions''.
MultiLineStringFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
multiplication (*):
See ``Arithmetic Operations''.
MULTIPOINT:
See ``MySQL Spatial Datatypes''.
MultiPoint():
See ``Creating Geometry Values Using MySQL-Specific Functions''.
MultiPointFromText():
See ``Creating Geometry Values Using WKT Functions''.
MultiPointFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
MULTIPOLYGON:
See ``MySQL Spatial Datatypes''.
MultiPolygon():
See ``Creating Geometry Values Using MySQL-Specific Functions''.
MultiPolygonFromText():
See ``Creating Geometry Values Using WKT Functions''.
MultiPolygonFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
my_init():
See ```my_init()'''.
my_ulonglong C type:
See ``C API Datatypes''.
my_ulonglong values, printing:
See ``C API Datatypes''.
MySQL C type:
See ``C API Prepared Statement Datatypes''.
MYSQL C type:
See ``C API Datatypes''.
mysql_affected_rows():
See ```mysql_affected_rows()'''.
mysql_autocommit().:
See ```mysql_autocommit()'''.
MYSQL_BIND C type:
See ``C API Prepared Statement Datatypes''.
mysql_bind_param():
See ```mysql_bind_param()'''.
mysql_bind_result():
See ```mysql_bind_result()'''.
mysql_change_user():
See ```mysql_change_user()'''.
mysql_character_set_name():
See ```mysql_character_set_name()'''.
mysql_close():
See ```mysql_close()'''.
mysql_commit().:
See ```mysql_commit()'''.
mysql_connect():
See ```mysql_connect()'''.
mysql_create_db():
See ```mysql_create_db()'''.
mysql_data_seek():
See ```mysql_data_seek()'''.
MYSQL_DEBUG environment variable <1>:
See ``Environment Variables''.
MYSQL_DEBUG environment variable <2>:
See ``Debugging a MySQL client''.
MYSQL_DEBUG environment variable:
See ``Overview of the Client-Side Scripts and Utilities''.
mysql_debug():
See ```mysql_debug()'''.
mysql_drop_db():
See ```mysql_drop_db()'''.
mysql_dump_debug_info():
See ```mysql_dump_debug_info()'''.
mysql_eof():
See ```mysql_eof()'''.
mysql_errno():
See ```mysql_errno()'''.
mysql_error():
See ```mysql_error()'''.
mysql_escape_string():
See ```mysql_escape_string()'''.
mysql_execute():
See ```mysql_execute()'''.
mysql_fetch():
See ```mysql_fetch()'''.
mysql_fetch_field():
See ```mysql_fetch_field()'''.
mysql_fetch_field_direct():
See ```mysql_fetch_field_direct()'''.
mysql_fetch_fields():
See ```mysql_fetch_fields()'''.
mysql_fetch_lengths():
See ```mysql_fetch_lengths()'''.
mysql_fetch_row():
See ```mysql_fetch_row()'''.
MYSQL_FIELD C type:
See ``C API Datatypes''.
mysql_field_count() <1>:
See ```mysql_num_fields()'''.
mysql_field_count():
See ```mysql_field_count()'''.
MYSQL_FIELD_OFFSET C type:
See ``C API Datatypes''.
mysql_field_seek():
See ```mysql_field_seek()'''.
mysql_field_tell():
See ```mysql_field_tell()'''.
mysql_free_result():
See ```mysql_free_result()'''.
mysql_get_client_info():
See ```mysql_get_client_info()'''.
mysql_get_host_info():
See ```mysql_get_host_info()'''.
mysql_get_metadata.:
See ```mysql_get_metadata()'''.
mysql_get_proto_info():
See ```mysql_get_proto_info()'''.
mysql_get_server_info():
See ```mysql_get_server_info()'''.
mysql_get_server_version():
See ```mysql_get_server_version()'''.
MYSQL_HISTFILE environment variable <1>:
See ``Environment Variables''.
MYSQL_HISTFILE environment variable:
See ``Overview of the Client-Side Scripts and Utilities''.
MYSQL_HOST environment variable <1>:
See ``Environment Variables''.
MYSQL_HOST environment variable:
See ``Connecting to the MySQL Server''.
mysql_info() <1>:
See ```mysql_info()'''.
mysql_info() <2>:
See ```ALTER TABLE' Syntax''.
mysql_info() <3>:
See ```LOAD DATA INFILE' Syntax''.
mysql_info() <4>:
See ```UPDATE' Syntax''.
mysql_info():
See ```INSERT' Syntax''.
mysql_init():
See ```mysql_init()'''.
mysql_insert_id() <1>:
See ```mysql_insert_id()'''.
mysql_insert_id():
See ``Transactions and Atomic Operations''.
mysql_insertid DBI attribute:
See ``The `DBI' Interface''.
mysql_kill():
See ```mysql_kill()'''.
mysql_list_dbs():
See ```mysql_list_dbs()'''.
mysql_list_fields():
See ```mysql_list_fields()'''.
mysql_list_processes():
See ```mysql_list_processes()'''.
mysql_list_tables():
See ```mysql_list_tables()'''.
mysql_more_results().:
See ```mysql_more_results()'''.
mysql_next_result().:
See ```mysql_next_result()'''.
mysql_num_fields():
See ```mysql_num_fields()'''.
mysql_num_rows():
See ```mysql_num_rows()'''.
mysql_options():
See ```mysql_options()'''.
mysql_param_count():
See ```mysql_param_count()'''.
mysql_ping():
See ```mysql_ping()'''.
mysql_prepare():
See ```mysql_prepare()'''.
MYSQL_PS1 environment variable:
See ``Environment Variables''.
MYSQL_PWD environment variable <1>:
See ``Environment Variables''.
MYSQL_PWD environment variable <2>:
See ``Overview of the Client-Side Scripts and Utilities''.
MYSQL_PWD environment variable:
See ``Connecting to the MySQL Server''.
mysql_query() <1> <1> ```mysql_reload()'''.
MYSQL_RES C type:
See ``C API Datatypes''.
mysql_rollback().:
See ```mysql_rollback()'''.
MYSQL_ROW C type:
See ``C API Datatypes''.
mysql_row_seek():
See ```mysql_row_seek()'''.
mysql_row_tell():
See ```mysql_row_tell()'''.
mysql_select_db():
See ```mysql_select_db()'''.
mysql_send_long_data().:
See ```mysql_send_long_data()'''.
mysql_server_end():
See ```mysql_server_end()'''.
mysql_server_init():
See ```mysql_server_init()'''.
mysql_shutdown():
See ```mysql_shutdown()'''.
mysql_sqlstate():
See ```mysql_sqlstate()'''.
mysql_stat():
See ```mysql_stat()'''.
MYSQL_STMT C type:
See ``C API Prepared Statement Datatypes''.
mysql_stmt_affected_rows():
See ```mysql_stmt_affected_rows()'''.
mysql_stmt_close():
See ```mysql_stmt_close()'''.
mysql_stmt_data_seek():
See ```mysql_stmt_data_seek()'''.
mysql_stmt_errno():
See ```mysql_stmt_errno()'''.
mysql_stmt_error().:
See ```mysql_stmt_error()'''.
mysql_stmt_num_rows():
See ```mysql_stmt_num_rows()'''.
mysql_stmt_row_seek():
See ```mysql_stmt_row_seek()'''.
mysql_stmt_row_tell():
See ```mysql_stmt_row_tell()'''.
mysql_stmt_sqlstate():
See ```mysql_stmt_sqlstate()'''.
mysql_stmt_store_result():
See ```mysql_stmt_store_result()'''.
mysql_store_result() <1>:
See ``Common questions and problems when using the C API''.
mysql_store_result():
See ```mysql_store_result()'''.
MYSQL_TCP_PORT environment variable <1>:
See ``Environment Variables''.
MYSQL_TCP_PORT environment variable <2>:
See ``Overview of the Client-Side Scripts and Utilities''.
MYSQL_TCP_PORT environment variable <3>:
See ``Using Client Programs in a Multiple-Server Environment''.
MYSQL_TCP_PORT environment variable:
See ``Running Multiple Servers on Unix''.
mysql_thread_end():
See ```mysql_thread_end()'''.
mysql_thread_id():
See ```mysql_thread_id()'''.
mysql_thread_init():
See ```mysql_thread_init()'''.
mysql_thread_safe():
See ```mysql_thread_safe()'''.
MYSQL_UNIX_PORT environment variable <1>:
See ``Environment Variables''.
MYSQL_UNIX_PORT environment variable <2>:
See ``Overview of the Client-Side Scripts and Utilities''.
MYSQL_UNIX_PORT environment variable <3>:
See ``Using Client Programs in a Multiple-Server Environment''.
MYSQL_UNIX_PORT environment variable <4>:
See ``Running Multiple Servers on Unix''.
MYSQL_UNIX_PORT environment variable:
See ``Problems Running `mysql_install_db'''.
mysql_use_result():
See ```mysql_use_result()'''.
NAME DBI method:
See ``The `DBI' Interface''.
NATIONAL CHAR:
See ``Column Types''.
NATURAL LEFT JOIN:
See ```JOIN' Syntax''.
NATURAL LEFT OUTER JOIN:
See ```JOIN' Syntax''.
NATURAL RIGHT JOIN:
See ```JOIN' Syntax''.
NATURAL RIGHT OUTER JOIN:
See ```JOIN' Syntax''.
NCHAR:
See ``Column Types''.
newline (\n):
See ``Strings''.
NOT BETWEEN:
See ``Comparison Operators''.
not equal (!=):
See ``Comparison Operators''.
not equal (<>):
See ``Comparison Operators''.
NOT IN:
See ``Comparison Operators''.
NOT LIKE:
See ``String Comparison Functions''.
NOT REGEXP:
See ``String Comparison Functions''.
NOT, logical:
See ``Logical Operators''.
NOW():
See ``Date and Time Functions''.
NUL:
See ``Strings''.
NULL <1>:
See ``Problems with `NULL' Values''.
NULL:
See ``Working with `NULL' Values''.
NULL value:
See ```NULL' Values''.
NULLABLE DBI method:
See ``The `DBI' Interface''.
NULLIF():
See ``Control Flow Functions''.
NUM_OF_FIELDS DBI method:
See ``The `DBI' Interface''.
NUMERIC:
See ``Column Types''.
NumGeometries():
See ```GeometryCollection' Property Analysis Functions''.
NumInteriorRings():
See ```Polygon' Property Analysis Functions''.
NumPoints():
See ```LineString' Property Analysis Functions''.
OCT():
See ``String Functions''.
OCTET_LENGTH():
See ``String Functions''.
OLD_PASSWORD():
See ``Miscellaneous Functions''.
Operators, logical:
See ``Logical Operators''.
OPTIMIZE TABLE:
See ```OPTIMIZE TABLE' Syntax''.
OR, bitwise:
See ``Bit Functions''.
OR, logical:
See ``Logical Operators''.
ORD():
See ``String Functions''.
ORDER BY:
See ```ALTER TABLE' Syntax''.
Overlaps():
See ``Functions That Test Spatial Relationships Between Geometries''.
parentheses ( and ):
See ``Parentheses''.
PASSWORD() <1>:
See ```Ignoring user' Error''.
PASSWORD() <2>:
See ``Miscellaneous Functions''.
PASSWORD() <3>:
See ``Setting Up Passwords''.
PASSWORD():
See ``Access Control, Stage 1: Connection Verification''.
PATH environment variable <1>
See ``Date and Time Functions''.
PI():
See ``Mathematical Functions''.
POINT:
See ``MySQL Spatial Datatypes''.
Point():
See ``Creating Geometry Values Using MySQL-Specific Functions''.
PointFromText():
See ``Creating Geometry Values Using WKT Functions''.
PointFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
PointN():
See ```LineString' Property Analysis Functions''.
PointOnSurface() <1> Using WKT Functions''.
PolyFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
POLYGON:
See ``MySQL Spatial Datatypes''.
Polygon():
See ``Creating Geometry Values Using MySQL-Specific Functions''.
PolygonFromText():
See ``Creating Geometry Values Using WKT Functions''.
PolygonFromWKB():
See ``Creating Geometry Values Using WKB Functions''.
POSITION():
See ``String Functions''.
POW():
See ``Mathematical Functions''.
POWER():
See ``Mathematical Functions''.
prepare() DBI method:
See ``The `DBI' Interface''.
PRIMARY KEY <1> LOGS'''.
QUARTER():
See ``Date and Time Functions''.
QUOTE():
See ``String Functions''.
quote() DBI method:
See ``The `DBI' Interface''.
quoting of identifiers:
See ``Database, Table, Index, Column, and Alias Names''.
RADIANS():
See ``Mathematical Functions''.
RAND():
See ``Mathematical Functions''.
REAL:
See ``Column Types''.
ref_or_null:
See ``How MySQL Optimises `IS NULL'''.
REGEXP:
See ``String Comparison Functions''.
Related():
See ``Functions That Test Spatial Relationships Between Geometries''.
RELEASE_LOCK():
See ``Miscellaneous Functions''.
RENAME TABLE:
See ```RENAME TABLE' Syntax''.
REPAIR TABLE:
See ```REPAIR TABLE' Syntax''.
REPEAT():
See ``String Functions''.
REPLACE:
See ```REPLACE' Syntax''.
REPLACE ... SELECT:
See ```INSERT' Syntax''.
REPLACE():
See ``String Functions''.
REQUIRE GRANT option:
See ``SSL `GRANT' Options''.
RESET MASTER:
See ```RESET MASTER'''.
RESET SLAVE:
See ```RESET SLAVE'''.
RESTORE TABLE:
See ```RESTORE TABLE' Syntax''.
return (\r):
See ``Strings''.
REVERSE():
See ``String Functions''.
REVOKE:
See ```GRANT' and `REVOKE' Syntax''.
RIGHT JOIN:
See ```JOIN' Syntax''.
RIGHT OUTER JOIN:
See ```JOIN' Syntax''.
RIGHT():
See ``String Functions''.
RLIKE:
See ``String Comparison Functions''.
ROLLBACK <1> TO SAVEPOINT' Syntax''.
ROLLUP:
See ```GROUP BY' Modifiers''.
ROUND():
See ``Mathematical Functions''.
rows DBI method:
See ``The `DBI' Interface''.
RPAD():
See ``String Functions''.
RTRIM():
See ``String Functions''.
SAVEPOINT:
See ```SAVEPOINT' and `ROLLBACK TO SAVEPOINT' Syntax''.
SEC_TO_TIME():
See ``Date and Time Functions''.
SECOND():
See ``Date and Time Functions''.
SELECT:
See ```SELECT' Syntax''.
SELECT INTO TABLE:
See ```SELECT INTO TABLE'''.
SELECT speed:
See ``Speed of `SELECT' Queries''.
SELECT, optimising:
See ```EXPLAIN' Syntax (Get Information About a `SELECT')''.
SESSION_USER():
See ``Miscellaneous Functions''.
SET <1>:
See ``The `SET' Type''.
SET <2> Syntax''.
SET PASSWORD statement:
See ``Setting Up Passwords''.
SET SQL_LOG_BIN:
See ```SET SQL_LOG_BIN'''.
SET TRANSACTION:
See ```SET TRANSACTION' Syntax''.
SHA():
See ``Miscellaneous Functions''.
SHA1():
See ``Miscellaneous Functions''.
SHOW BINLOG EVENTS:
See ```SHOW BINLOG EVENTS'''.
SHOW COLUMNS:
See ```SHOW' Syntax''.
SHOW CREATE TABLE <1>:
See ```SHOW CREATE TABLE'''.
SHOW CREATE TABLE:
See ```SHOW' Syntax''.
SHOW DATABASES:
See ```SHOW' Syntax''.
SHOW FIELDS:
See ```SHOW' Syntax''.
SHOW GRANTS <1>:
See ```SHOW GRANTS'''.
SHOW GRANTS:
See ```SHOW' Syntax''.
SHOW INDEX:
See ```SHOW' Syntax''.
SHOW KEYS:
See ```SHOW' Syntax''.
SHOW MASTER LOGS <1>:
See ```SHOW MASTER LOGS'''.
SHOW MASTER LOGS:
See ```SHOW' Syntax''.
SHOW MASTER STATUS <1>:
See ```SHOW MASTER STATUS'''.
SHOW MASTER STATUS:
See ```SHOW' Syntax''.
SHOW PRIVILEGES:
See ```SHOW PRIVILEGES'''.
SHOW PROCESSLIST <1>:
See ```SHOW PROCESSLIST'''.
SHOW PROCESSLIST:
See ```SHOW' Syntax''.
SHOW SLAVE HOSTS:
See ```SHOW SLAVE HOSTS'''.
SHOW SLAVE STATUS <1>:
See ```SHOW SLAVE STATUS'''.
SHOW SLAVE STATUS:
See ```SHOW' Syntax''.
SHOW STATUS:
See ```SHOW' Syntax''.
SHOW TABLE STATUS:
See ```SHOW' Syntax''.
SHOW TABLE TYPES <1>:
See ```SHOW TABLE TYPES'''.
SHOW TABLE TYPES:
See ```SHOW' Syntax''.
SHOW TABLES:
See ```SHOW' Syntax''.
SHOW VARIABLES:
See ```SHOW' Syntax''.
SHOW WARNINGS <1>:
See ```SHOW WARNINGS | ERRORS'''.
SHOW WARNINGS:
See ```SHOW' Syntax''.
SIGN():
See ``Mathematical Functions''.
SIN():
See ``Mathematical Functions''.
single quote (\'):
See ``Strings''.
SMALLINT:
See ``Column Types''.
SOUNDEX():
See ``String Functions''.
SOUNDS LIKE:
See ``String Comparison Functions''.
SPACE():
See ``String Functions''.
SQL_CACHE:
See ``Query Cache Options in `SELECT'''.
SQL_NO_CACHE:
See ``Query Cache Options in `SELECT'''.
SQRT():
See ``Mathematical Functions''.
SRID():
See ``General Geometry Property Analysis Functions''.
START SLAVE:
See ```START SLAVE'''.
START TRANSACTION:
See ```START TRANSACTION', `COMMIT', and `ROLLBACK' Syntax''.
StartPoint():
See ```LineString' Property Analysis Functions''.
statements, GRANT:
See ``Adding New Users to MySQL''.
statements, INSERT:
See ``Adding New Users to MySQL''.
STD():
See ```GROUP BY' Functions''.
STDDEV():
See ```GROUP BY' Functions''.
STOP SLAVE:
See ```STOP SLAVE'''.
STRAIGHT_JOIN:
See ```JOIN' Syntax''.
STRCMP():
See ``String Comparison Functions''.
string comparison functions:
See ``String Comparison Functions''.
string functions:
See ``String Functions''.
SUBDATE():
See ``Date and Time Functions''.
SUBSTRING():
See ``String Functions''.
SUBSTRING_INDEX():
See ``String Functions''.
SUBTIME():
See ``Date and Time Functions''.
subtraction (-):
See ``Arithmetic Operations''.
SUM():
See ```GROUP BY' Functions''.
SymDifference():
See ``Spatial Operators''.
SYSDATE():
See ``Date and Time Functions''.
SYSTEM_USER():
See ``Miscellaneous Functions''.
tab (\t):
See ``Strings''.
table DBI method:
See ``The `DBI' Interface''.
Table scan:
See ``How to avoid table scan,,,''.
table_cache:
See ``How MySQL Opens and Closes Tables''.
TAN():
See ``Mathematical Functions''.
TEXT <1>:
See ``The `BLOB' and `TEXT' Types''.
TEXT:
See ``Column Types''.
threads:
See ```SHOW PROCESSLIST'''.
TIME <1>:
See ``The `TIME' Type''.
TIME:
See ``Column Types''.
TIME():
See ``Date and Time Functions''.
TIME_FORMAT():
See ``Date and Time Functions''.
TIME_TO_SEC():
See ``Date and Time Functions''.
TIMEDIFF():
See ``Date and Time Functions''.
TIMESTAMP <1>:
See ``The `DATETIME', `DATE', and `TIMESTAMP' Types''.
TIMESTAMP:
See ``Column Types''.
TIMESTAMP():
See ``Date and Time Functions''.
TINYBLOB:
See ``Column Types''.
TINYINT:
See ``Column Types''.
TINYTEXT:
See ``Column Types''.
TMPDIR environment variable <1>:
See ``Environment Variables''.
TMPDIR environment variable:
See ``Problems Running `mysql_install_db'''.
TO_DAYS():
See ``Date and Time Functions''.
Touches():
See ``Functions That Test Spatial Relationships Between Geometries''.
trace DBI method <1>:
See ``Debugging mysqld under gdb''.
trace DBI method:
See ``The `DBI' Interface''.
TRIM():
See ``String Functions''.
TRUE:
See ``Numbers''.
TRUNCATE:
See ```TRUNCATE' Syntax''.
TRUNCATE():
See ``Mathematical Functions''.
type DBI method:
See ``The `DBI' Interface''.
Types:
See ``Column Types''.
TZ environment variable <1>:
See ``Environment Variables''.
TZ environment variable:
See ``Time Zone Problems''.
UCASE():
See ``String Functions''.
UDF functions:
See ```CREATE FUNCTION/DROP FUNCTION' Syntax''.
ulimit:
See ``File Not Found''.
UMASK environment variable <1>:
See ``Environment Variables''.
UMASK environment variable:
See ``Problems with File Permissions''.
UMASK_DIR environment variable <1>:
See ``Environment Variables''.
UMASK_DIR environment variable:
See ``Problems with File Permissions''.
unary minus (-):
See ``Mathematical Functions''.
UNCOMPRESS():
See ``Miscellaneous Functions''.
UNCOMPRESSED_LENGTH():
See ``Miscellaneous Functions''.
UNION <1>:
See ```UNION' Syntax''.
UNION:
See ``Searching on Two Keys''.
Union():
See ``Spatial Operators''.
UNIQUE:
See ```ALTER TABLE' Syntax''.
UNIX_TIMESTAMP():
See ``Date and Time Functions''.
UNLOCK TABLES:
See ```LOCK TABLES' and `UNLOCK TABLES' Syntax''.
UPDATE:
See ```UPDATE' Syntax''.
UPPER():
See ``String Functions''.
USE:
See ```USE' Syntax''.
USE INDEX <1>:
See ```JOIN' Syntax''.
USE INDEX:
See ```SELECT' Syntax''.
USE KEY <1>:
See ```JOIN' Syntax''.
USE KEY:
See ```SELECT' Syntax''.
USER environment variable <1>:
See ``Environment Variables''.
USER environment variable:
See ``Connecting to the MySQL Server''.
USER():
See ``Miscellaneous Functions''.
User-defined functions:
See ```CREATE FUNCTION/DROP FUNCTION' Syntax''.
UTC_DATE():
See ``Date and Time Functions''.
UTC_TIME():
See ``Date and Time Functions''.
UTC_TIMESTAMP():
See ``Date and Time Functions''.
VARCHAR <1> See ``Miscellaneous Functions''.
WEEK():
See ``Date and Time Functions''.
WEEKDAY():
See ``Date and Time Functions''.
WEEKOFYEAR():
See ``Date and Time Functions''.
WHERE:
See ``How MySQL Optimises `WHERE' Clauses''.
Wildcard character (%):
See ``Strings''.
Wildcard character (_):
See ``Strings''.
Within():
See ``Functions That Test Spatial Relationships Between Geometries''.
without-server option:
See ``Typical `configure' Options''.
X():
See ```Point' Property Analysis Functions''.
XOR, bitwise:
See ``Bit Functions''.
XOR, logical:
See ``Logical Operators''.
Y():
See ```Point' Property Analysis Functions''.
YEAR <1>:
See ``The `YEAR' Type''.
YEAR:
See ``Column Types''.
YEAR():
See ``Date and Time Functions''.
| (bitwise OR):
See ``Bit Functions''.
|| (logical OR):
See ``Logical Operators''.
~:
See ``Bit Functions''.
[Назад] [Содержание] [Вперед]
| Главная |