Function Index

Symbols | A | B | C | D | E | F | G | H | I | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y

Symbols

[index top]

%

Section 1.9.4, “MySQL Extensions to Standard SQL”

A

[index top]

ABS()

Section 18.2, “Adding New Functions to MySQL”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 8.2.3, “Function Name Parsing and Resolution”
Section 11.6.2, “Mathematical Functions”

ACOS()

Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section 11.6.2, “Mathematical Functions”

ADDDATE()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

addslashes()

Section 5.4.1, “General Security Guidelines”

ADDTIME()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section 11.7, “Date and Time Functions”

AES_DECRYPT()

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.28, “Changes in Release 4.0.4 (29 September 2002)”
Section 11.12, “Encryption and Compression Functions”

AES_ENCRYPT()

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.12, “Encryption and Compression Functions”

Area()

Section 16.5.2, “Geometry Functions”
Section 16.5.2.6, “MultiPolygon Functions”
Section 16.5.2.5, “Polygon Functions”

AsBinary()

Section 16.4.5, “Fetching Spatial Data”
Section 16.5.1, “Geometry Format Conversion Functions”

ASCII()

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 12.7.3, “HELP Syntax”
Section 11.5, “String Functions”

ASIN()

Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section 11.6.2, “Mathematical Functions”

AsText()

Section 16.4.5, “Fetching Spatial Data”
Section 16.5.1, “Geometry Format Conversion Functions”

AsWKB()

Section 16.5.1, “Geometry Format Conversion Functions”

AsWKT()

Section 16.5.1, “Geometry Format Conversion Functions”

ATAN()

Section 11.6.2, “Mathematical Functions”

ATAN2()

Section 11.6.2, “Mathematical Functions”

AVG()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section 10.1.2, “Date and Time Type Overview”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 10.4.4, “The ENUM Type”
Section 1.3.2, “The Main Features of MySQL”
Section 10.4.5, “The SET Type”

B

[index top]

BdMPolyFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

BdMPolyFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

BdPolyFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

BdPolyFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

BENCHMARK()

Section 7.5.3.1, “How the Query Cache Operates”
Section 11.13, “Information Functions”
Section 7.3.1, “Optimizing SELECT Statements”
Section 12.2.8.10, “Optimizing Subqueries”
Section 12.2.8.8, “Subqueries in the FROM Clause”

BIN()

Section 11.5, “String Functions”

BIT_AND()

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

BIT_COUNT()

Section 11.11, “Bit Functions”
Section C.2.5, “Changes in Release 4.0.27 (06 May 2006)”
Section 1.9.4, “MySQL Extensions to Standard SQL”

BIT_LENGTH()

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.5, “String Functions”

BIT_OR()

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

BIT_XOR()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

Boundary()

Section 16.5.2.1, “General Geometry Functions”

Buffer()

Section 16.5.3.2, “Spatial Operators”

C

[index top]

CAST()

Section 11.10, “Cast Functions and Operators”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.3.2, “Comparison Functions and Operators”
Section 9.1.8.2, “CONVERT() and CAST()”
Section 8.1.4, “Hexadecimal Literals”
Section 1.9.5, “MySQL Differences from Standard SQL”
Section 9.1.8.1, “Result Strings”
Section 9.1.7.7, “The BINARY Operator”
Section 11.2, “Type Conversion in Expression Evaluation”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

CEIL()

Section 11.6.2, “Mathematical Functions”

CEILING()

Section 11.6.2, “Mathematical Functions”

Centroid()

Section 16.5.2.6, “MultiPolygon Functions”

CHAR()

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 11.12, “Encryption and Compression Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

CHAR_LENGTH()

Section C.3.55, “Changes in Release 3.23.6 (15 December 1999)”
Section 11.5, “String Functions”

CHARACTER_LENGTH()

Section 11.5, “String Functions”

CHARSET()

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section 11.13, “Information Functions”
Section 9.1.8.1, “Result Strings”

COALESCE()

Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section 11.3.2, “Comparison Functions and Operators”

COERCIBILITY()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 9.1.7.5, “Collation of Expressions”
Section 11.13, “Information Functions”

COLLATION()

Section B.5.5.1, “Case Sensitivity in String Searches”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section 11.13, “Information Functions”
Section 9.1.8.1, “Result Strings”

COMPRESS()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 11.12, “Encryption and Compression Functions”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”

CONCAT()

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.3.47, “Changes in Release 3.23.14 (09 April 2000)”
Section 9.1.7.5, “Collation of Expressions”
Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 9.1.8.1, “Result Strings”
Section 12.2.8.11, “Rewriting Subqueries as Joins for Earlier MySQL Versions”
Section 5.1.6, “Server SQL Modes”
Section 11.5, “String Functions”
Section 11.2, “Type Conversion in Expression Evaluation”

CONCAT_WS()

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.24, “Changes in Release 3.23.36 (27 March 2001)”
Section C.3.9, “Changes in Release 3.23.51 (31 May 2002)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 11.5, “String Functions”

CONNECTION_ID()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.47, “Changes in Release 3.23.14 (09 April 2000)”
Section 7.5.3.1, “How the Query Cache Operates”
Section 11.13, “Information Functions”
Section 14.7.6, “Replication and System Functions”

Contains()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

CONV()

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.42, “Changes in Release 3.23.19”
Section 11.6.2, “Mathematical Functions”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

CONVERT()

Section 11.10, “Cast Functions and Operators”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 11.3.2, “Comparison Functions and Operators”
Section 9.1.8.2, “CONVERT() and CAST()”
Section 11.14, “Miscellaneous Functions”

CONVERT_TZ()

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section 11.7, “Date and Time Functions”
Section 7.5.3.1, “How the Query Cache Operates”
Section 14.7.18, “Replication and Time Zones”
Section 14.7, “Replication Features and Issues”

ConvexHull()

Section 16.5.3.2, “Spatial Operators”

COS()

Section 11.6.2, “Mathematical Functions”

COT()

Section 11.6.2, “Mathematical Functions”

COUNT()

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.3.49, “Changes in Release 3.23.12 (07 March 2000)”
Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.20, “Changes in Release 3.23.40 (18 July 2001)”
Section C.3.56, “Changes in Release 3.23.5 (20 October 1999)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 3.3.4.8, “Counting Rows”
Section 12.4.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
Section 7.2.2, “EXPLAIN Output Format”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section B.5.5.3, “Problems with NULL Values”
Section 5.1.6, “Server SQL Modes”
Section 1.3.2, “The Main Features of MySQL”
Section 7.3.1.2, “WHERE Clause Optimization”

CRC32()

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section 11.6.2, “Mathematical Functions”

create_temp_file()

Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”

Crosses()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

crypt()

Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 11.12, “Encryption and Compression Functions”
Section 5.1.3, “Server System Variables”

CURDATE()

Section 11.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”
Section 7.5.3.1, “How the Query Cache Operates”

CURRENT_DATE

Section 12.1.5, “CREATE TABLE Syntax”
Section 10.1.4, “Data Type Default Values”
Section 11.7, “Date and Time Functions”

CURRENT_DATE()

Section 11.7, “Date and Time Functions”
Section 7.5.3.1, “How the Query Cache Operates”

CURRENT_TIME

Section 11.7, “Date and Time Functions”

CURRENT_TIME()

Section 11.7, “Date and Time Functions”
Section 7.5.3.1, “How the Query Cache Operates”

CURRENT_TIMESTAMP

Section 12.1.5, “CREATE TABLE Syntax”
Section 10.1.4, “Data Type Default Values”
Section 11.7, “Date and Time Functions”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”

CURRENT_TIMESTAMP()

Section 11.7, “Date and Time Functions”
Section 7.5.3.1, “How the Query Cache Operates”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”

CURRENT_USER

Section 5.5.4, “Access Control, Stage 1: Connection Verification”
Section 11.13, “Information Functions”
Section 5.5.2, “Privilege System Grant Tables”

CURRENT_USER()

Section 5.5.4, “Access Control, Stage 1: Connection Verification”
Section 5.6.8, “Auditing MySQL Account Activity”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 11.13, “Information Functions”
Section 14.7.6, “Replication and System Functions”
Section 12.4.1.4, “SET PASSWORD Syntax”
Section 12.4.5.12, “SHOW GRANTS Syntax”
Section 9.1.10, “UTF-8 for Metadata”

CURTIME()

Section 11.7, “Date and Time Functions”
Section 7.5.3.1, “How the Query Cache Operates”
Section 9.7, “MySQL Server Time Zone Support”

D

[index top]

DATABASE()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 3.3.1, “Creating and Selecting a Database”
Section 12.1.6, “DROP DATABASE Syntax”
Section 3.4, “Getting Information About Databases and Tables”
Section 7.5.3.1, “How the Query Cache Operates”
Section 11.13, “Information Functions”
Section B.5.8.4, “Open Issues in MySQL”
Section 9.1.10, “UTF-8 for Metadata”

DATE()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section 11.7, “Date and Time Functions”

DATE_ADD()

Section 11.6.1, “Arithmetic Operators”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section 11.7, “Date and Time Functions”
Section 10.3, “Date and Time Types”
Section 3.3.4.5, “Date Calculations”
Section 8.5, “Expression Syntax”

DATE_FORMAT()

Section 17.6.16, “C API Prepared Statement Problems”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section C.3.53, “Changes in Release 3.23.8 (02 January 2000)”
Section 11.7, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

DATE_SUB()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.3.39, “Changes in Release 3.23.22 (31 July 2000)”
Section 11.7, “Date and Time Functions”
Section 10.3, “Date and Time Types”

DATEDIFF()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

DAY()

Section 11.7, “Date and Time Functions”

DAYNAME()

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 11.7, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

DAYOFMONTH()

Section 11.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”

DAYOFWEEK()

Section 11.7, “Date and Time Functions”

DAYOFYEAR()

Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section 11.7, “Date and Time Functions”

DECODE()

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 11.12, “Encryption and Compression Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

DEFAULT()

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section 12.2.4, “INSERT Syntax”
Section 11.14, “Miscellaneous Functions”
Section 12.2.6, “REPLACE Syntax”

DEGREES()

Section 11.6.2, “Mathematical Functions”

DES_DECRYPT()

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 11.12, “Encryption and Compression Functions”
Section 5.1.2, “Server Command Options”

DES_ENCRYPT()

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 11.12, “Encryption and Compression Functions”
Section 5.1.2, “Server Command Options”

dict_load_table()

Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”

Difference()

Section 16.5.3.2, “Spatial Operators”

Dimension()

Section 16.5.2.1, “General Geometry Functions”

Disjoint()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

Distance()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

E

[index top]

ELT()

Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section B.5.8.4, “Open Issues in MySQL”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

ENCODE()

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 11.12, “Encryption and Compression Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

ENCRYPT()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 1.10.1, “Contributors to MySQL”
Section 11.12, “Encryption and Compression Functions”
Section 7.5.3.1, “How the Query Cache Operates”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 5.1.3, “Server System Variables”
Section 5.6.1, “User Names and Passwords”

EndPoint()

Section 16.5.3.1, “Geometry Functions That Produce New Geometries”
Section 16.5.2.3, “LineString Functions”
Section 16.5.2.4, “MultiLineString Functions”

Envelope()

Section 16.5.2.1, “General Geometry Functions”
Section 16.5.3.1, “Geometry Functions That Produce New Geometries”

Equals()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

exit()

Section C.4.4, “Changes in MySQL/InnoDB-4.1.2, May 30, 2004”

EXP()

Section 11.6.2, “Mathematical Functions”

EXPORT_SET()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section 11.5, “String Functions”

expr IN ()

Section 11.3.2, “Comparison Functions and Operators”

expr NOT IN ()

Section 11.3.2, “Comparison Functions and Operators”

ExteriorRing()

Section 16.5.3.1, “Geometry Functions That Produce New Geometries”
Section 16.5.2.5, “Polygon Functions”

EXTRACT()

Section 11.10, “Cast Functions and Operators”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section 11.7, “Date and Time Functions”

F

[index top]

FIELD()

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section 11.5, “String Functions”

fil_flush_file_spaces()

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”

FIND_IN_SET()

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.3.44, “Changes in Release 3.23.17 (07 June 2000)”
Section 11.5, “String Functions”
Section 10.4.5, “The SET Type”

FLOOR()

Section 11.6.1, “Arithmetic Operators”
Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section C.3.55, “Changes in Release 3.23.6 (15 December 1999)”
Section 11.6.2, “Mathematical Functions”

FORMAT()

Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 11.6.2, “Mathematical Functions”
Section 11.14, “Miscellaneous Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

FOUND_ROWS()

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 7.5.3.1, “How the Query Cache Operates”
Section 11.13, “Information Functions”
Section 1.5, “MySQL 4.0 in a Nutshell”
Section 14.7.6, “Replication and System Functions”

FROM_DAYS()

Section 11.7, “Date and Time Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

FROM_UNIXTIME()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section 1.10.1, “Contributors to MySQL”
Section 11.7, “Date and Time Functions”
Section 14.7.18, “Replication and Time Zones”

fsync()

Section C.4.48, “Changes in MySQL/InnoDB-3.23.38, May 12, 2001”

G

[index top]

GeomCollFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

GeomCollFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryCollection()

Section 16.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

GeometryCollectionFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

GeometryCollectionFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

GeometryFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

GeometryN()

Section 16.5.3.1, “Geometry Functions That Produce New Geometries”
Section 16.5.2.7, “GeometryCollection Functions”

GeometryType()

Section 16.5.2.1, “General Geometry Functions”

GeomFromText()

Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 16.5.1, “Geometry Format Conversion Functions”
Section 16.4.4, “Populating Spatial Columns”

GeomFromWKB()

Section 16.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”
Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”
Section 16.5.1, “Geometry Format Conversion Functions”

GET_FORMAT()

Section 11.7, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”

GET_LOCK()

Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section 17.6.14, “Controlling Automatic Reconnection Behavior”
Section 7.11.2, “General Thread States”
Section 7.5.3.1, “How the Query Cache Operates”
Section 7.6.1, “Internal Locking Methods”
Section 12.4.6.3, “KILL Syntax”
Section 11.14, “Miscellaneous Functions”
Section 17.6.6.3, “mysql_change_user()”
Section 14.7.6, “Replication and System Functions”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”

gethostbyaddr()

Section 7.8.5, “How MySQL Uses DNS”

gethostbyaddr_r()

Section 7.8.5, “How MySQL Uses DNS”

gethostbyname()

Section 7.8.5, “How MySQL Uses DNS”

gethostbyname_r()

Section 7.8.5, “How MySQL Uses DNS”

GLength()

Section 16.5.2.3, “LineString Functions”
Section 16.5.2.4, “MultiLineString Functions”
Section 16.7, “MySQL Conformance and Compatibility”

GREATEST()

Section 11.3.2, “Comparison Functions and Operators”
Section 9.1.8.1, “Result Strings”

GROUP_CONCAT()

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.18, “Changes in MySQL 4.1.8 (2004-12-14)”
Section C.1, “Changes in Release 4.1.x (Lifecycle Support Ended)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 1.6, “MySQL 4.1 in a Nutshell”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section B.5.8.4, “Open Issues in MySQL”
Section 5.1.3, “Server System Variables”
Section 1.3.2, “The Main Features of MySQL”

H

[index top]

HEX()

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 9.1.3.5, “Character String Literal Character Set and Collation”
Section 8.1.4, “Hexadecimal Literals”
Section 11.6.2, “Mathematical Functions”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

HOUR()

Section C.3.30, “Changes in Release 3.23.31 (17 January 2001: Production)”
Section 11.7, “Date and Time Functions”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”

I

[index top]

IF()

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.21, “Changes in Release 3.23.39 (12 June 2001)”
Section C.3.9, “Changes in Release 3.23.51 (31 May 2002)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 11.4, “Control Flow Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section B.5.8.4, “Open Issues in MySQL”
Section 9.1.8.1, “Result Strings”

IFNULL()

Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 11.4, “Control Flow Functions”
Section B.5.5.3, “Problems with NULL Values”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

IN

Section 11.3.1, “Operator Precedence”

IN()

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 7.2.2, “EXPLAIN Output Format”
Section D.1, “Restrictions on Subqueries”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 11.2, “Type Conversion in Expression Evaluation”

INET_ATON()

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section 11.14, “Miscellaneous Functions”

INET_NTOA()

Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.14, “Miscellaneous Functions”

INSERT()

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 11.5, “String Functions”

INSTR()

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

InteriorRingN()

Section 16.5.3.1, “Geometry Functions That Produce New Geometries”
Section 16.5.2.5, “Polygon Functions”

Intersection()

Section 16.5.3.2, “Spatial Operators”

Intersects()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

INTERVAL()

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section 11.3.2, “Comparison Functions and Operators”

IS_FREE_LOCK()

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.14, “Miscellaneous Functions”
Section 14.7.6, “Replication and System Functions”

IS_USED_LOCK()

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 11.14, “Miscellaneous Functions”
Section 14.7.6, “Replication and System Functions”

IsClosed()

Section 16.5.2.4, “MultiLineString Functions”

IsEmpty()

Section 16.5.2.1, “General Geometry Functions”

ISNULL()

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.9, “Changes in Release 3.23.51 (31 May 2002)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section 11.3.2, “Comparison Functions and Operators”

IsRing()

Section 16.5.2.3, “LineString Functions”

IsSimple()

Section 16.5.2.1, “General Geometry Functions”

L

[index top]

LAST_DAY()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 11.7, “Date and Time Functions”

LAST_INSERT_ID()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.36, “Changes in Release 3.23.25 (29 September 2000)”
Section C.3.56, “Changes in Release 3.23.5 (20 October 1999)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section 11.3.2, “Comparison Functions and Operators”
Section 17.6.14, “Controlling Automatic Reconnection Behavior”
Section 12.1.5, “CREATE TABLE Syntax”
Section 7.5.3.1, “How the Query Cache Operates”
Section 17.6.13.3, “How to Get the Unique ID for the Last Inserted Row”
Section 11.13, “Information Functions”
Section 12.2.4.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 12.2.4.2, “INSERT DELAYED Syntax”
Section 12.2.4, “INSERT Syntax”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 17.6.6.35, “mysql_insert_id()”
Section 17.6.10.16, “mysql_stmt_insert_id()”
Section 14.7.1, “Replication and AUTO_INCREMENT”
Section 5.1.3, “Server System Variables”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”
Section 1.9.5.4, “Transactions and Atomic Operations”
Section 14.11, “Troubleshooting Replication”
Section 3.6.9, “Using AUTO_INCREMENT”

LCASE()

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

LEAST()

Section 11.3.2, “Comparison Functions and Operators”
Section 9.1.8.1, “Result Strings”

LEFT()

Section 11.10, “Cast Functions and Operators”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 11.5, “String Functions”

LENGTH()

Section 11.5, “String Functions”

Length()

Section 16.5.2.3, “LineString Functions”
Section 16.5.2.4, “MultiLineString Functions”
Section 16.7, “MySQL Conformance and Compatibility”

LineFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 16.5.1, “Geometry Format Conversion Functions”

LineFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”
Section 16.5.1, “Geometry Format Conversion Functions”

LineString()

Section 16.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

LineStringFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

LineStringFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

LN()

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 11.6.2, “Mathematical Functions”

LOAD_FILE()

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section 7.5.3.1, “How the Query Cache Operates”
Section 5.5.1, “Privileges Provided by MySQL”
Section 14.7.6, “Replication and System Functions”
Section 11.5, “String Functions”

LOCALTIME

Section 11.7, “Date and Time Functions”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”

LOCALTIME()

Section 11.7, “Date and Time Functions”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”

LOCALTIMESTAMP

Section 11.7, “Date and Time Functions”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”

LOCALTIMESTAMP()

Section 11.7, “Date and Time Functions”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”

LOCATE()

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section 11.5, “String Functions”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

LOG()

Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 11.6.2, “Mathematical Functions”

LOG10()

Section 11.6.2, “Mathematical Functions”

LOG2()

Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section 11.6.2, “Mathematical Functions”

LOWER()

Section 11.10, “Cast Functions and Operators”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”
Section 9.1.12.1, “Unicode Character Sets”

LPAD()

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section 11.5, “String Functions”

LTRIM()

Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

M

[index top]

MAKE_SET()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.33, “Changes in Release 3.23.28 (22 November 2000: Gamma)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section 11.5, “String Functions”

MAKEDATE()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

MAKETIME()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

MASTER_POS_WAIT()

Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.2.22, “Changes in Release 4.0.10 (29 January 2003)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section 7.5.3.1, “How the Query Cache Operates”
Section 11.14, “Miscellaneous Functions”
Section 14.10, “Replication FAQ”

MATCH

Section 8.5, “Expression Syntax”

MATCH ()

Section 11.9, “Full-Text Search Functions”

MATCH()

Section 11.9.2, “Boolean Full-Text Searches”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section 11.9.6, “Fine-Tuning MySQL Full-Text Search”
Section 11.9.5, “Full-Text Restrictions”
Section 11.9, “Full-Text Search Functions”
Section 11.9.1, “Natural Language Full-Text Searches”

MAX()

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.4.42, “Changes in MySQL/InnoDB-3.23.44, November 2, 2001”
Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.3.16, “Changes in Release 3.23.44 (31 October 2001)”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.3.2, “Changes in Release 3.23.58 (11 September 2003)”
Section C.3.53, “Changes in Release 3.23.8 (02 January 2000)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 7.4.3, “How MySQL Uses Indexes”
Section 11.15.3, “MySQL Handling of GROUP BY”
Section 10.1.1, “Numeric Type Overview”
Section B.5.8.4, “Open Issues in MySQL”
Section 12.2.8.10, “Optimizing Subqueries”
Section 1.3.2, “The Main Features of MySQL”
Section 10.3.6, “Two-Digit Years in Dates”
Section 3.6.9, “Using AUTO_INCREMENT”

MBRContains()

Section 16.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
Section 16.6.2, “Using a Spatial Index”

MBRDisjoint()

Section 16.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBREqual()

Section 16.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRIntersects()

Section 16.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBROverlaps()

Section 16.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRTouches()

Section 16.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”

MBRWithin()

Section 16.5.5, “Relations on Geometry Minimal Bounding Rectangles (MBRs)”
Section 16.6.2, “Using a Spatial Index”

MD5()

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 8.2, “Database, Table, Index, Column, and Alias Names”
Section 11.12, “Encryption and Compression Functions”
Section 5.4.1, “General Security Guidelines”
Section 5.4.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 1.9.4, “MySQL Extensions to Standard SQL”

mem_realloc()

Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”

MICROSECOND()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

MID()

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”

MIN()

Section 17.6.16, “C API Prepared Statement Problems”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.1.23, “Changes in MySQL 4.1.3 (2004-06-28, Beta)”
Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”
Section C.3.38, “Changes in Release 3.23.23 (01 September 2000)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.17, “Changes in Release 4.0.15 (03 September 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 7.4.3, “How MySQL Uses Indexes”
Section 11.15.3, “MySQL Handling of GROUP BY”
Section 10.1.1, “Numeric Type Overview”
Section B.5.8.4, “Open Issues in MySQL”
Section 12.2.8.10, “Optimizing Subqueries”
Section B.5.5.3, “Problems with NULL Values”
Section 1.3.2, “The Main Features of MySQL”
Section 10.3.6, “Two-Digit Years in Dates”
Section 7.3.1.2, “WHERE Clause Optimization”

MINUTE()

Section 11.7, “Date and Time Functions”

MLineFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

MLineFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

MOD()

Section 11.6.1, “Arithmetic Operators”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section 3.3.4.5, “Date Calculations”
Section 11.6.2, “Mathematical Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

MONTH()

Section 11.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”

MONTHNAME()

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 11.7, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”
Section 5.1.3, “Server System Variables”
Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

MPointFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

MPointFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

MPolyFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

MPolyFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiLineString()

Section 16.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiLineStringFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiLineStringFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiPoint()

Section 16.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiPointFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiPointFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

MultiPolygon()

Section 16.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

MultiPolygonFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

MultiPolygonFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

my_strxfrm_MYSET()

Section 9.4, “Adding a New Character Set”

my_thread_end()

Section C.3.19, “Changes in Release 3.23.41 (11 August 2001)”

my_thread_init()

Section C.3.19, “Changes in Release 3.23.41 (11 August 2001)”

mysql_bind_param()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_bind_result()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_escape_string()

Section 5.4.1, “General Security Guidelines”

mysql_execute()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_fetch()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_fetch_column()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_get_metadata()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_list_tables()

Section 17.6.6.42, “mysql_list_tables()”

mysql_odbc_escape_string()

Section C.3.55, “Changes in Release 3.23.6 (15 December 1999)”

mysql_param_count()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_param_result()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_prepare()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_prepare_result()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”

mysql_real_escape_string()

Section 5.4.1, “General Security Guidelines”

mysql_rm_db()

Section C.2.10, “Changes in Release 4.0.22 (27 October 2004)”

mysql_send_long_data()

Section 17.6.10, “C API Prepared Statement Function Descriptions”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”

mysql_sha1_result

Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”

mysql_shutdown()

Section 2.11.1.1, “Upgrading from MySQL 4.0 to 4.1”

N

[index top]

NOW()

Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.3.27, “Changes in Release 3.23.34 (10 March 2001)”
Section C.2.26, “Changes in Release 4.0.6 (14 December 2002: Gamma)”
Section 12.1.5, “CREATE TABLE Syntax”
Section 10.1.4, “Data Type Default Values”
Section 11.7, “Date and Time Functions”
Section 7.5.3.1, “How the Query Cache Operates”
Section 9.7, “MySQL Server Time Zone Support”
Section 14.7.18, “Replication and Time Zones”
Section 10.3.3, “The YEAR Type”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”

NULLIF()

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.3.46, “Changes in Release 3.23.15 (08 May 2000)”
Section C.3.42, “Changes in Release 3.23.19”
Section 11.4, “Control Flow Functions”

NumGeometries()

Section 16.5.2.7, “GeometryCollection Functions”

NumInteriorRings()

Section 16.5.2.5, “Polygon Functions”

NumPoints()

Section 16.5.2.3, “LineString Functions”

O

[index top]

OCT()

Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”
Section 11.6.2, “Mathematical Functions”

OCTET_LENGTH()

Section 11.5, “String Functions”

OLD_PASSWORD()

Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section B.5.2.4, “Client does not support authentication protocol”
Section 11.12, “Encryption and Compression Functions”
Section 5.4.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 5.4.2.3, “Password Hashing in MySQL”
Section 12.4.1.4, “SET PASSWORD Syntax”

ORD()

Section C.3.55, “Changes in Release 3.23.6 (15 December 1999)”
Section 11.5, “String Functions”

Overlaps()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

P

[index top]

page_dir_find_slot()

Section C.4.12, “Changes in MySQL/InnoDB-3.23.58, September 15, 2003”

PASSWORD()

Section 5.5.4, “Access Control, Stage 1: Connection Verification”
Section 5.6.2, “Adding User Accounts”
Section 5.4.2.1, “Administrator Guidelines for Password Security”
Section 5.6.5, “Assigning Account Passwords”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section 11.12, “Encryption and Compression Functions”
Section 12.4.1.2, “GRANT Syntax”
Section B.5.2.15, “Ignoring user”
Section 5.4.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 5.4.2.3, “Password Hashing in MySQL”
Section 5.4.2.5, “Password Hashing in MySQL 4.1.0”
Section 14.7.6, “Replication and System Functions”
Section 2.10.3, “Securing the Initial MySQL Accounts”
Section 12.4.1.4, “SET PASSWORD Syntax”
Section 5.6.1, “User Names and Passwords”

PERIOD_ADD()

Section 11.7, “Date and Time Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

PERIOD_DIFF()

Section 11.7, “Date and Time Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

PI()

Section 11.6.2, “Mathematical Functions”

POINT()

Section 16.3.1, “Well-Known Text (WKT) Format”

Point()

Section 16.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

PointFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”
Section 16.5.1, “Geometry Format Conversion Functions”

PointFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”
Section 16.5.1, “Geometry Format Conversion Functions”

PointN()

Section 16.5.3.1, “Geometry Functions That Produce New Geometries”
Section 16.5.2.3, “LineString Functions”

PolyFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

PolyFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

Polygon()

Section 16.4.2.3, “Creating Geometry Values Using MySQL-Specific Functions”

PolygonFromText()

Section 16.4.2.1, “Creating Geometry Values Using WKT Functions”

PolygonFromWKB()

Section 16.4.2.2, “Creating Geometry Values Using WKB Functions”

POSITION()

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 11.5, “String Functions”

POW()

Section 11.6.2, “Mathematical Functions”

POWER()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 11.6.2, “Mathematical Functions”

pread()

Section C.4.6, “Changes in MySQL/InnoDB-4.0.19, May 4, 2004”

pthread_mutex()

Section 1.10.1, “Contributors to MySQL”

pthread_mutex_destroy()

Section C.4.16, “Changes in MySQL/InnoDB-4.0.13, May 20, 2003”

pwrite()

Section C.4.6, “Changes in MySQL/InnoDB-4.0.19, May 4, 2004”

Q

[index top]

QUARTER()

Section 11.7, “Date and Time Functions”

QUOTE()

Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.8, “Changes in Release 4.0.24 (04 March 2005)”
Section C.2.29, “Changes in Release 4.0.3 (26 August 2002: Beta)”
Section C.2.24, “Changes in Release 4.0.8 (07 January 2003)”
Section 11.5, “String Functions”

R

[index top]

RADIANS()

Section 11.6.2, “Mathematical Functions”

RAND()

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.19, “Changes in MySQL 4.1.7 (2004-10-23, Production)”
Section C.3.8, “Changes in Release 3.23.52 (14 August 2002)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.31, “Changes in Release 4.0.1 (23 December 2001)”
Section C.2.20, “Changes in Release 4.0.12 (15 March 2003: Production)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 7.5.3.1, “How the Query Cache Operates”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 11.6.2, “Mathematical Functions”
Section 14.7.6, “Replication and System Functions”
Section 5.1.3, “Server System Variables”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

realloc()

Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”

Related()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

RELEASE_LOCK()

Section 12.2.2, “DO Syntax”
Section 7.5.3.1, “How the Query Cache Operates”
Section 7.6.1, “Internal Locking Methods”
Section 11.14, “Miscellaneous Functions”
Section 14.7.6, “Replication and System Functions”
Section 12.3.5.2, “Table-Locking Restrictions and Conditions”

REPEAT()

Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

REPLACE()

Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.22, “Changes in Release 3.23.38 (09 May 2001)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

REVERSE()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

RIGHT()

Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 3.3.4.5, “Date Calculations”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

ROUND()

Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 11.6.2, “Mathematical Functions”
Section B.5.5.8, “Problems with Floating-Point Values”

row_mysql_lock_data_dictionary()

Section C.4.11, “Changes in MySQL/InnoDB-4.0.16, October 22, 2003”

RPAD()

Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.3.32, “Changes in Release 3.23.29 (16 December 2000)”
Section B.5.8.2, “Issues in MySQL 4.0 Fixed in a Later Version”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

RTRIM()

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

S

[index top]

SEC_TO_TIME()

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 11.7, “Date and Time Functions”

SECOND()

Section 11.7, “Date and Time Functions”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”

SESSION_USER()

Section 11.13, “Information Functions”
Section 9.1.10, “UTF-8 for Metadata”

setrlimit()

Section 5.1.2, “Server Command Options”

SHA()

Section C.1.5, “Changes in MySQL 4.1.21 (2006-07-19)”
Section 11.12, “Encryption and Compression Functions”

SHA1()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.12, “Encryption and Compression Functions”
Section 5.4.1, “General Security Guidelines”
Section 5.4.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”

sha1_result

Section C.1.9, “Changes in MySQL 4.1.17 (Not released)”

SIGN()

Section 11.6.2, “Mathematical Functions”

SIN()

Section 11.6.2, “Mathematical Functions”
Section 18.2.2.3, “UDF Argument Processing”

SOUNDEX()

Section 18.2, “Adding New Functions to MySQL”
Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section C.2.13, “Changes in Release 4.0.19 (04 May 2004)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

SPACE()

Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

SQRT()

Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section 11.6.2, “Mathematical Functions”

SRID()

Section 16.5.2.1, “General Geometry Functions”

StartPoint()

Section 16.5.3.1, “Geometry Functions That Produce New Geometries”
Section 16.5.2.3, “LineString Functions”
Section 16.5.2.4, “MultiLineString Functions”

STD()

Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 1.3.2, “The Main Features of MySQL”

STDDEV()

Section 11.15.1, “GROUP BY (Aggregate) Functions”

STR_TO_DATE()

Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section C.1.8, “Changes in MySQL 4.1.18 (2006-01-27)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section 11.7, “Date and Time Functions”
Section 9.8, “MySQL Server Locale Support”

STRCMP()

Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section B.5.5.2, “Problems Using DATE Columns”
Section 11.5.1, “String Comparison Functions”
Section 2.11.1.2, “Upgrading from MySQL 3.23 to 4.0”

SUBDATE()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

SUBSTR()

Section 11.5, “String Functions”

SUBSTRING()

Section 5.6.8, “Auditing MySQL Account Activity”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section C.1, “Changes in Release 4.1.x (Lifecycle Support Ended)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”
Section 10.4.3, “The BLOB and TEXT Types”

SUBSTRING_INDEX()

Section C.3.35, “Changes in Release 3.23.26 (18 October 2000)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 11.5, “String Functions”

SUBTIME()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

SUM()

Section 18.2.2, “Adding a New User-Defined Function”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section C.3.57, “Changes in Release 3.23.4 (28 September 1999)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 10.1.2, “Date and Time Type Overview”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section B.5.5.3, “Problems with NULL Values”
Section 10.4.4, “The ENUM Type”
Section 1.3.2, “The Main Features of MySQL”
Section 10.4.5, “The SET Type”

SymDifference()

Section 16.5.3.2, “Spatial Operators”

SYSDATE()

Section 11.7, “Date and Time Functions”
Section 7.5.3.1, “How the Query Cache Operates”

SYSTEM_USER()

Section 11.13, “Information Functions”
Section 9.1.10, “UTF-8 for Metadata”

T

[index top]

TAN()

Section 11.6.2, “Mathematical Functions”

thr_setconcurrency()

Section 5.1.3, “Server System Variables”

TIME()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

TIME_FORMAT()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 11.7, “Date and Time Functions”

TIME_TO_SEC()

Section C.3.15, “Changes in Release 3.23.45 (22 November 2001)”
Section 11.7, “Date and Time Functions”

TIMEDIFF()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.16, “Changes in MySQL 4.1.10 (2005-02-12)”
Section C.1.14, “Changes in MySQL 4.1.12 (2005-05-13)”
Section C.1.10, “Changes in MySQL 4.1.16 (2005-11-29)”
Section 11.7, “Date and Time Functions”

TIMESTAMP()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

tmpfile()

Section C.4.1, “Changes in MySQL/InnoDB-4.0.21, September 10, 2004”
Section C.4.2, “Changes in MySQL/InnoDB-4.1.4, August 31, 2004”

TO_DAYS()

Section 11.7, “Date and Time Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

Touches()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

TRIM()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section C.3.29, “Changes in Release 3.23.32 (22 January 2001)”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

TRUNCATE()

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.6.2, “Mathematical Functions”

U

[index top]

UCASE()

Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”

UNCOMPRESS()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section 11.12, “Encryption and Compression Functions”
Section 2.9.3, “MySQL Source-Configuration Options”
Section 5.1.3, “Server System Variables”

UNCOMPRESSED_LENGTH()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.12, “Encryption and Compression Functions”

UNHEX()

Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section C.1.22, “Changes in MySQL 4.1.4 (2004-08-26, Gamma)”
Section 11.12, “Encryption and Compression Functions”
Section 11.5, “String Functions”

Union()

Section 16.5.3.2, “Spatial Operators”

UNIX_TIMESTAMP()

Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.14, “Changes in Release 4.0.18 (12 February 2004)”
Section C.2.9, “Changes in Release 4.0.23 (18 December 2004)”
Section 11.7, “Date and Time Functions”
Section 7.5.3.1, “How the Query Cache Operates”
Section 14.7.6, “Replication and System Functions”
Section B.5.4.6, “Time Zone Problems”
Section 10.3.1.1, “TIMESTAMP Properties Prior to MySQL 4.1”

UPPER()

Section 11.10, “Cast Functions and Operators”
Section C.3.54, “Changes in Release 3.23.7 (10 December 1999)”
Section 9.1.8.1, “Result Strings”
Section 11.5, “String Functions”
Section 9.1.12.1, “Unicode Character Sets”

USER()

Section 5.6.8, “Auditing MySQL Account Activity”
Section 5.5.7, “Causes of Access-Denied Errors”
Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.12, “Changes in MySQL 4.1.14 (2005-08-17)”
Section C.2.19, “Changes in Release 4.0.13 (16 May 2003)”
Section 9.1.7.5, “Collation of Expressions”
Section 9.1.7.4, “Collations Must Be for the Right Character Set”
Section 7.5.3.1, “How the Query Cache Operates”
Section 11.13, “Information Functions”
Section 14.7.6, “Replication and System Functions”
Section 9.1.10, “UTF-8 for Metadata”

UTC_DATE

Section 11.7, “Date and Time Functions”

UTC_DATE()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

UTC_TIME

Section 11.7, “Date and Time Functions”

UTC_TIME()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

UTC_TIMESTAMP

Section 11.7, “Date and Time Functions”
Section 10.3.1.2, “TIMESTAMP Properties as of MySQL 4.1”

UTC_TIMESTAMP()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”
Section 9.7, “MySQL Server Time Zone Support”

UUID()

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.24, “Changes in MySQL 4.1.2 (2004-05-28)”
Section 7.5.3.1, “How the Query Cache Operates”
Section 11.14, “Miscellaneous Functions”
Section 14.7.6, “Replication and System Functions”

V

[index top]

VALUES()

Section C.1.4, “Changes in MySQL 4.1.22 (2006-11-02)”
Section 12.2.4.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
Section 11.14, “Miscellaneous Functions”

VARIANCE()

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”

VERSION()

Section B.5.5.1, “Case Sensitivity in String Searches”
Section C.1.15, “Changes in MySQL 4.1.11 (2005-04-01)”
Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.3.10, “Changes in Release 3.23.50 (21 April 2002)”
Section 9.1.7.5, “Collation of Expressions”
Section 11.13, “Information Functions”
Section 9.1.10, “UTF-8 for Metadata”

W

[index top]

WEEK()

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.18, “Changes in Release 4.0.14 (18 July 2003)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 11.7, “Date and Time Functions”
Section 5.1.3, “Server System Variables”

WEEKDAY()

Section 11.7, “Date and Time Functions”
Section 1.9.4, “MySQL Extensions to Standard SQL”

WEEKOFYEAR()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”
Section 11.7, “Date and Time Functions”

Within()

Section 16.5.6, “Functions That Test Spatial Relationships Between Geometries”

X

[index top]

X()

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 16.5.2.2, “Point Functions”

XXX()

Section C.1.25, “Changes in MySQL 4.1.1 (2003-12-01)”

Y

[index top]

Y()

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 16.5.2.2, “Point Functions”

YEAR()

Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section 11.7, “Date and Time Functions”
Section 3.3.4.5, “Date Calculations”

YEARWEEK()

Section C.3.53, “Changes in Release 3.23.8 (02 January 2000)”
Section 11.7, “Date and Time Functions”