- MySQL 5.1 Reference Manual :: Function Index
-
- MySQL 5.1 Reference Manual
- Preface, Notes, Licenses
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL Enterprise Monitor
- 16 Replication
- 17 MySQL Cluster NDB 6.X/7.X
- 18 Partitioning
- 19 Stored Programs and Views
- 20 INFORMATION_SCHEMA Tables
- 21 Connectors and APIs
- 22 Extending MySQL
- A MySQL 5.1 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- Index
- Standard Index
- C Function Index
- Command Index
- Function Index
- INFORMATION_SCHEMA Index
- Transaction Isolation Level Index
- JOIN Types Index
- Operator Index
- Option Index
- Privileges Index
- SQL Modes Index
- Status Variable Index
- Statement/Syntax Index
- System Variable Index
ABS()
ADDDATE()
ADDDATE(date,INTERVAL expr unit)
ADDDATE(expr,days)
ADDTIME()
ADDTIME(expr1,expr2)
AES_DECRYPT()
AES_DECRYPT(crypt_str,key_str)
AES_ENCRYPT()
AES_ENCRYPT(str,key_str)
ASCII(str)
ATAN(Y,X)
ATAN2(Y,X)
AVG()
AVG(DISTINCT)
AVG([DISTINCT] expr)
Area(mpoly)
Area(poly)
AsBinary()
BENCHMARK()
BENCHMARK(10, (SELECT * FROM t))
BENCHMARK(count,expr)
BENCHMARK(loop_count,expression)
BIT_AND(expr)
BIT_COUNT(N)
BIT_LENGTH()
BIT_LENGTH(str)
BIT_OR(expr)
BIT_XOR(expr)
BdMPolyFromText(wkt,srid)
BdMPolyFromWKB(wkb,srid)
BdPolyFromText(wkt,srid)
BdPolyFromWKB(wkb,srid)
Buffer(g,d)
CAST()
- Section 9.1.9.2, “
CONVERT()
andCAST()
” - Section 8.1.6, “Bit-Field Values”
- Section 11.9, “Cast Functions and Operators”
- Section 11.2.3, “Comparison Functions and Operators”
- Section 11.6, “Date and Time Functions”
- Section 10.3, “Date and Time Types”
- Section 1.8.5, “MySQL Differences from Standard SQL”
- Section 9.1.9.1, “Result Strings”
- Section 11.2.2, “Type Conversion in Expression Evaluation”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
- Section 8.4, “User-Defined Variables”
CAST(... AS UNSIGNED)
CAST(... COLLATE ...)
CAST(...) COLLATE ...
CAST(expr AS CHAR)
CAST(expr AS type)
CAST(str AS BINARY)
CEILING()
CEILING(3.7004397181411)
CEILING(X)
CHAR()
CHAR(0)
CHAR(1,0)
CHAR(1,0,0)
CHAR(128 | key_num)
CHAR(256)
CHAR(256*256)
CHAR(N,... [USING charset_name])
CHARACTER_LENGTH()
CHARACTER_LENGTH(str)
CHARSET()
CHARSET(str)
CHAR_LENGTH()
CHAR_LENGTH(str)
COALESCE(a.c1,b.c1)
COALESCE(value,...)
COERCIBILITY(str)
COLLATION()
COLLATION(str)
COMPRESS()
COMPRESS(string_to_compress)
CONCAT()
- Section 12.4.3.2, “
CREATE FUNCTION
Syntax” - Section 11.12.1, “
GROUP BY
(Aggregate) Functions” - Section 12.4.5.14, “
SHOW CREATE VIEW
Syntax” - Section 1.8.4, “MySQL Extensions to Standard SQL”
- Section 9.1.9.1, “Result Strings”
- Section 12.2.9.11, “Rewriting Subqueries as Joins”
- Section 5.1.7, “Server SQL Modes”
- Section 11.4, “String Functions”
- Section 9.1.8, “String Repertoire”
- Section 20.15, “The
INFORMATION_SCHEMA VIEWS
Table” - Section 11.2.2, “Type Conversion in Expression Evaluation”
- Section 11.10, “XML Functions”
CONCAT(1, 'abc')
CONCAT(p1.id, p1.tvab) + 0 AS tvid
CONCAT(str1,str2,...)
CONCAT_WS(separator,str1,str2,...)
CONNECTION_ID()
CONV(N,10,16)
CONV(N,10,2)
CONV(N,from_base,to_base)
CONVERT()
- Section 9.1.9.2, “
CONVERT()
andCAST()
” - Section 11.9, “Cast Functions and Operators”
- Section 9.1.3.5, “Character String Literal Character Set and Collation”
- Section 11.2.3, “Comparison Functions and Operators”
- Section 11.11.4, “Miscellaneous Functions”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
CONVERT(... USING ...)
CONVERT(expr USING transcoding_name)
CONVERT(expr,type)
CONVERT_TZ()
CONVERT_TZ(...,...,@@global.time_zone)
CONVERT_TZ(...,...,@@session.time_zone)
CONVERT_TZ(dt,from_tz,to_tz)
COUNT()
- Section 12.4.3.2, “
CREATE FUNCTION
Syntax” - Section 11.12.1, “
GROUP BY
(Aggregate) Functions” - Section 7.2.4, “
WHERE
Clause Optimization” - Section 3.3.4.8, “Counting Rows”
- Section 18.1, “Overview of Partitioning in MySQL”
- Section B.5.5.3, “Problems with
NULL
Values” - Section 5.1.7, “Server SQL Modes”
- Section 19.5.3, “Updatable and Insertable Views”
- Section 19.5.2, “View Processing Algorithms”
COUNT(*)
COUNT(DISTINCT ...)
COUNT(DISTINCT expr,[expr...])
COUNT(DISTINCT value_list)
COUNT(DISTINCT)
CRC32(expr)
CURDATE()
CURRENT_DATE
CURRENT_DATE()
CURRENT_TIME()
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP()
CURRENT_USER
- Section 12.1.11, “
CREATE EVENT
Syntax” - Section 12.1.15, “
CREATE PROCEDURE
andCREATE FUNCTION
Syntax” - Section 12.1.19, “
CREATE TRIGGER
Syntax” - Section 12.1.20, “
CREATE VIEW
Syntax” - Section 19.6, “Access Control for Stored Programs and Views”
- Section 11.11.3, “Information Functions”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.11, “Replication and System Functions”
CURRENT_USER()
- Section 12.1.11, “
CREATE EVENT
Syntax” - Section 12.1.15, “
CREATE PROCEDURE
andCREATE FUNCTION
Syntax” - Section 12.1.19, “
CREATE TRIGGER
Syntax” - Section 12.1.20, “
CREATE VIEW
Syntax” - Section 12.4.5.22, “
SHOW GRANTS
Syntax” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 5.5.8, “Auditing MySQL Account Activity”
- Section 11.11.3, “Information Functions”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.11, “Replication and System Functions”
- Section 9.1.11, “UTF-8 for Metadata”
CURTIME()
Centroid(mpoly)
ConvexHull(g)
Create_func_abs
Create_func_arg0
Create_func_arg1
Create_func_arg2
Create_func_arg3
Create_func_concat
Create_func_lcase
Create_func_lpad
Create_func_pow
Create_func_uuid
Create_native_func
DATABASE()
- Section 12.1.21, “
DROP DATABASE
Syntax” - Section B.5.8.2, “Additional Known Issues”
- Section 3.3.1, “Creating and Selecting a Database”
- Section 3.4, “Getting Information About Databases and Tables”
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 11.11.3, “Information Functions”
- Section B.5.8.1, “Open Issues in MySQL”
- Section 9.1.11, “UTF-8 for Metadata”
DATE(expr)
DATEDIFF()
DATEDIFF(expr1,expr2)
DATE_ADD()
DATE_ADD(date,INTERVAL expr unit)
DATE_FORMAT()
DATE_FORMAT(date,format)
DATE_SUB(date,INTERVAL expr unit)
DAY()
DAY(date)
DAYNAME()
DAYNAME(date)
DAYOFMONTH()
DAYOFMONTH(date)
DAYOFWEEK(date)
DAYOFYEAR()
DAYOFYEAR(date)
DECODE()
DECODE(crypt_str,pass_str)
DEFAULT(col_name)
DEFAULT(i)
DEGREES(X)
DES_DECRYPT()
DES_DECRYPT(crypt_str[,key_str])
DES_ENCRYPT()
DES_ENCRYPT(str[,{key_num|key_str}])
Difference(g1,g2)
Dimension(g)
ELT()
ELT(N,str1,str2,str3,...)
ENCODE()
ENCODE(str,pass_str)
ENCRYPT()
ENCRYPT(str[,salt])
EXPORT_SET(bits,on,off[,separator[,number_of_bits]])
EXTRACT()
EXTRACT(unit FROM date)
EndPoint()
EndPoint(ls)
Envelope(g)
ExteriorRing(poly)
ExtractValue('<a><b>Sakila</b></a>', '/a/b')
ExtractValue('<a><b>Sakila</b></a>', '/a/b/text()')
ExtractValue(xml_frag, xpath_expr)
FIELD()
FIELD(str,str1,str2,str3,...)
FIND_IN_SET(str,strlist)
FLOOR()
FLOOR(i RAND() * (j
FORMAT()
FORMAT(X,D)
FORMAT(X,D[,locale])
FOUND_ROWS()
FROM_DAYS()
FROM_DAYS(N)
FROM_UNIXTIME()
FROM_UNIXTIME(unix_timestamp)
FROM_UNIXTIME(unix_timestamp,format)
GET_FORMAT(DATE,'EUR')
GET_FORMAT(DATE,'INTERNAL')
GET_FORMAT(DATE,'ISO')
GET_FORMAT(DATE,'JIS')
GET_FORMAT(DATE,'USA')
GET_FORMAT(DATETIME,'EUR')
GET_FORMAT(DATETIME,'INTERNAL')
GET_FORMAT(DATETIME,'ISO')
GET_FORMAT(DATETIME,'JIS')
GET_FORMAT(DATETIME,'USA')
GET_FORMAT(TIME,'EUR')
GET_FORMAT(TIME,'INTERNAL')
GET_FORMAT(TIME,'ISO')
GET_FORMAT(TIME,'JIS')
GET_FORMAT(TIME,'USA')
GET_FORMAT({DATE|TIME|DATETIME}, {'EUR'|'USA'|'JIS'|'ISO'|'INTERNAL'})
GET_LOCK()
- Section 12.1.11, “
CREATE EVENT
Syntax” - Section 12.4.6.4, “
KILL
Syntax” - Section 21.9.3.3, “
mysql_change_user()
” - Section 21.9.11, “Controlling Automatic Reconnection Behavior”
- Section 7.5.6.2, “General Thread States”
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 7.3.1, “Internal Locking Methods”
- Section 11.11.4, “Miscellaneous Functions”
- Section 12.3.5.3, “Other Table-Locking Notes”
- Section 16.4.1.11, “Replication and System Functions”
GET_LOCK(str,timeout)
GLength()
GLength(ls)
GLength(mls)
GREATEST(value1,value2,...)
GREATEST(x,NULL)
GROUP_CONCAT()
GROUP_CONCAT(expr)
GeomCollFromText(wkt[,srid])
GeomCollFromWKB(wkb[,srid])
GeomFromText()
GeomFromText(wkt[,srid])
GeomFromWKB()
GeomFromWKB(wkb[,srid])
GeometryCollection(g1,g2,...)
GeometryCollectionFromText(wkt[,srid])
GeometryCollectionFromWKB(wkb[,srid])
GeometryFromText(wkt[,srid])
GeometryFromWKB(wkb[,srid])
GeometryN(gc,N)
GeometryType(g)
HEX()
HEX(str)
HOUR(time)
IF()
IF(expr1,expr2,expr3)
IFNULL(expr1,expr2)
IN()
IN(value_list)
INET_ATON()
INET_ATON(expr)
INET_NTOA()
INET_NTOA(expr)
INSERT(str,pos,len,newstr)
INSTR(str,substr)
INTERVAL(N,N1,N2,N3,...)
ISNULL(expr)
IS_FREE_LOCK()
IS_FREE_LOCK(str)
IS_USED_LOCK()
IS_USED_LOCK(str)
InteriorRingN(poly,N)
Intersection(g1,g2)
IsClosed(mls)
IsRing(ls)
LAST_DAY()
LAST_DAY(date)
LAST_INSERT_ID()
- Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
- Section 12.1.17, “
CREATE TABLE
Syntax” - Section 12.2.5.3, “
INSERT ... ON DUPLICATE KEY UPDATE
Syntax” - Section 12.2.5.2, “
INSERT DELAYED
Syntax” - Section 12.2.5, “
INSERT
Syntax” - Section 21.9.3.37, “
mysql_insert_id()
” - Section 11.2.3, “Comparison Functions and Operators”
- Section 21.9.11, “Controlling Automatic Reconnection Behavior”
- Description
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 21.9.10.3, “How to Get the Unique ID for the Last Inserted Row”
- Section 11.11.3, “Information Functions”
- Section 1.8.4, “MySQL Extensions to Standard SQL”
- Section 12.3.5.3, “Other Table-Locking Notes”
- Section 16.4.1.1, “Replication and
AUTO_INCREMENT
” - Section 5.1.4, “Server System Variables”
- Section 19.2.4, “Stored Procedures, Functions, Triggers, and
LAST_INSERT_ID()
” - Section 1.8.5.3, “Transactions and Atomic Operations”
- Section 16.4.5, “Troubleshooting Replication”
- Section 19.5.3, “Updatable and Insertable Views”
- Section 3.6.9, “Using
AUTO_INCREMENT
”
LAST_INSERT_ID(expr)
LCASE(str)
LEAST(value1,value2,...)
LEAST(x,NULL)
LEFT(str,len)
LENGTH()
LENGTH(str)
LOAD_FILE()
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 5.4.1, “Privileges Provided by MySQL”
- Section 16.4.1.11, “Replication and System Functions”
- Section 5.3.4, “Security-Related mysqld Options”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
LOAD_FILE(file_name)
LOCATE()
LOCATE(substr,str)
LOCATE(substr,str,pos)
LOG(10,X)
LOG(X) / LOG(2)
LOG(X) / LOG(B)
LOWER()
LOWER(str)
LPAD(str,len,padstr)
LTRIM(str)
Length()
LineFromText()
LineFromText(wkt[,srid])
LineFromWKB(wkb[,srid])
LineString(pt1,pt2,...)
LineStringFromText(wkt[,srid])
LineStringFromWKB(wkb[,srid])
MAKEDATE()
MAKEDATE(year,dayofyear)
MAKETIME()
MAKETIME(hour,minute,second)
MAKE_SET(bits,str1,str2,...)
MASTER_POS_WAIT()
MASTER_POS_WAIT(log_name,log_pos[,timeout])
MATCH (col1,col2,...) AGAINST (expr [search_modifier])
MATCH()
MATCH() ... AGAINST
MATCH() ... AGAINST()
MAX()
- Section 11.12.1, “
GROUP BY
(Aggregate) Functions” - Section 11.12.3, “
GROUP BY
andHAVING
with Hidden Columns” - Section B.5.8.2, “Additional Known Issues”
- Section 11.2.3, “Comparison Functions and Operators”
- Section 7.4.4, “How MySQL Uses Indexes”
- Section 7.2.14.1, “Loose Index Scan”
- Section B.5.8.1, “Open Issues in MySQL”
- Section 7.2.1, “Optimizing Queries with
EXPLAIN
” - Section 12.2.9.10, “Optimizing Subqueries”
- Section 19.5.3, “Updatable and Insertable Views”
- Section 19.5.2, “View Processing Algorithms”
- Section 10.3.4, “Year 2000 Issues and Date Types”
MAX([DISTINCT] expr)
MAX(auto_increment_column) + 1 WHERE prefix=given-prefix
MAX(col_name)
MAX(t1.b)
MBRContains()
MBRIntersects(g1,g2)
MBRWithin()
MD5()
- Section 18.2.4, “
KEY
Partitioning” - Section 8.2, “Schema Object Names”
- Section 11.11.2, “Encryption and Compression Functions”
- Section 5.3.1, “General Security Guidelines”
- Section 5.3.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
- Section 1.8.4, “MySQL Extensions to Standard SQL”
MICROSECOND()
MICROSECOND(expr)
MID(expr,1,255)
MID(str,pos,len)
MIN()
- Section 11.12.1, “
GROUP BY
(Aggregate) Functions” - Section 11.12.3, “
GROUP BY
andHAVING
with Hidden Columns” - Section 7.2.4, “
WHERE
Clause Optimization” - Section B.5.8.2, “Additional Known Issues”
- Section 11.2.3, “Comparison Functions and Operators”
- Section 7.4.4, “How MySQL Uses Indexes”
- Section 7.2.14.1, “Loose Index Scan”
- Section B.5.8.1, “Open Issues in MySQL”
- Section 7.2.1, “Optimizing Queries with
EXPLAIN
” - Section 12.2.9.10, “Optimizing Subqueries”
- Section B.5.5.3, “Problems with
NULL
Values” - Section 19.5.3, “Updatable and Insertable Views”
- Section 19.5.2, “View Processing Algorithms”
- Section 10.3.4, “Year 2000 Issues and Date Types”
MIN(DATE_ADD(timestamp,INTERVAL 0 DAY))
MIN([DISTINCT] expr)
MIN(col_name)
MIN(number-with-zerofill)
MINUTE(time)
MLineFromText(wkt[,srid])
MLineFromWKB(wkb[,srid])
MOD()
MOD(X,0)
MOD(something,12)
MONTH()
MONTH(birth)
MONTH(date)
MONTHNAME()
MONTHNAME(date)
MPointFromText(wkt[,srid])
MPointFromWKB(wkb[,srid])
MPolyFromText(wkt[,srid])
MPolyFromWKB(wkb[,srid])
MultiLineString(ls1,ls2,...)
MultiLineStringFromText(wkt[,srid])
MultiLineStringFromWKB(wkb[,srid])
MultiPoint(pt1,pt2,...)
MultiPointFromText(wkt[,srid])
MultiPointFromWKB(wkb[,srid])
MultiPolygon(poly1,poly2,...)
MultiPolygonFromText(wkt[,srid])
MultiPolygonFromWKB(wkb[,srid])
NAME_CONST()
NAME_CONST(name,value)
NOW()
- Section 12.1.15, “
CREATE PROCEDURE
andCREATE FUNCTION
Syntax” - Section 12.1.17, “
CREATE TABLE
Syntax” - Section 10.3.1.1, “
TIMESTAMP
Properties” - Section 10.1.4, “Data Type Default Values”
- Section 11.6, “Date and Time Functions”
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 9.6, “MySQL Server Time Zone Support”
- Section 16.4.1.11, “Replication and System Functions”
- Section 16.4.1.26, “Replication and Time Zones”
- Section 5.1.2, “Server Command Options”
- Section 5.1.4, “Server System Variables”
- Section 10.3.1, “The
DATETIME
,DATE
, andTIMESTAMP
Types” - Section 10.3.3, “The
YEAR
Type” - Section 9.6.2, “Time Zone Leap Second Support”
- Section 2.4.1.1, “Upgrading from MySQL 5.0 to 5.1”
NULLIF(expr1,expr2)
NumGeometries(gc)
NumInteriorRings(poly)
NumPoints(ls)
OCTET_LENGTH()
OCTET_LENGTH(str)
OLD_PASSWORD()
- Section B.5.2.4, “
Client does not support authentication protocol
” - Section 12.4.1.6, “
SET PASSWORD
Syntax” - Section 11.11.2, “Encryption and Compression Functions”
- Section 5.3.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
- Section 5.3.2.3, “Password Hashing in MySQL”
OLD_PASSWORD(str)
ORD(str)
PASSWORD()
- Section 12.4.1.1, “
CREATE USER
Syntax” - Section 12.4.1.3, “
GRANT
Syntax” - Section B.5.2.15, “
Ignoring user
” - Section 18.2.4, “
KEY
Partitioning” - Section 12.4.1.6, “
SET PASSWORD
Syntax” - Section 5.4.4, “Access Control, Stage 1: Connection Verification”
- Section 5.5.2, “Adding User Accounts”
- Section 5.5.5, “Assigning Account Passwords”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 11.11.2, “Encryption and Compression Functions”
- Section 5.3.2.4, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
- Section 1.8.4, “MySQL Extensions to Standard SQL”
- Section 5.3.2.3, “Password Hashing in MySQL”
- Section 16.4.1.11, “Replication and System Functions”
- Section 2.13.2, “Securing the Initial MySQL Accounts”
- Section 5.5.1, “User Names and Passwords”
PASSWORD(str)
PERIOD_ADD()
PERIOD_ADD(P,N)
PERIOD_DIFF()
PERIOD_DIFF(P1,P2)
PI()
POSITION(substr IN str)
POW(5-int_col,3) + 6
POWER(2,4)
POWER(X,Y)
PointFromText()
PointFromText(wkt[,srid])
PointFromWKB()
PointFromWKB(wkb[,srid])
PointN(ls,N)
PolyFromText(wkt[,srid])
PolyFromWKB(wkb[,srid])
Polygon(ls1,ls2,...)
PolygonFromText(wkt[,srid])
PolygonFromWKB(wkb[,srid])
QUARTER(date)
QUOTE()
QUOTE(str)
RADIANS(X)
RAND()
- Section 4.6.7.1, “mysqlbinlog Hex Dump Format”
- Section 12.1.15, “
CREATE PROCEDURE
andCREATE FUNCTION
Syntax” - Description
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 11.5.2, “Mathematical Functions”
- Section 16.4.1.11, “Replication and System Functions”
- Section 5.1.4, “Server System Variables”
RAND(determinstic_expression)
RELEASE_LOCK()
RELEASE_LOCK(str)
REPEAT()
REPEAT(str,count)
REPLACE(str,from_str,to_str)
REVERSE()
REVERSE(str)
RIGHT(str,len)
ROUND()
ROUND(X,D)
ROW_COUNT()
RPAD(str,len,padstr)
RTRIM(str)
SECOND(time)
SEC_TO_TIME(seconds)
SHA1()
SHA2(str, hash_length)
SLEEP()
SLEEP(duration)
SOUNDEX()
SOUNDEX(expr1) = SOUNDEX(expr2)
SOUNDEX(str)
SPACE(N)
STD()
STDDEV(expr)
STDDEV_POP()
STDDEV_POP(expr)
STDDEV_SAMP()
STDDEV_SAMP(expr)
STRCMP()
STRCMP(expr1,expr2)
STR_TO_DATE(str,format)
SUBDATE()
SUBDATE(date,INTERVAL expr unit)
SUBDATE(expr,days)
SUBSTR()
SUBSTR(str FROM pos FOR len)
SUBSTR(str FROM pos)
SUBSTR(str,pos)
SUBSTR(str,pos,len)
SUBSTRING()
SUBSTRING(str FROM pos FOR len)
SUBSTRING(str FROM pos)
SUBSTRING(str,pos)
SUBSTRING(str,pos,len)
SUBSTRING_INDEX()
SUBSTRING_INDEX(str,delim,count)
SUBTIME()
SUBTIME(expr1,expr2)
SUM()
- Section 11.12.1, “
GROUP BY
(Aggregate) Functions” - Section 22.3.2, “Adding a New User-Defined Function”
- Section 10.1.2, “Overview of Date and Time Types”
- Section 18.1, “Overview of Partitioning in MySQL”
- Section B.5.5.3, “Problems with
NULL
Values” - Section 10.4.4, “The
ENUM
Type” - Section 10.4.5, “The
SET
Type” - Section 19.5.3, “Updatable and Insertable Views”
- Section 19.5.2, “View Processing Algorithms”
SUM(DISTINCT)
SUM([DISTINCT] expr)
SYSDATE()
StartPoint()
StartPoint(ls)
SymDifference(g1,g2)
TIME(expr)
TIMEDIFF()
TIMEDIFF(expr1,expr2)
TIMESTAMP()
TIMESTAMP(expr)
TIMESTAMP(expr1,expr2)
TIMESTAMPADD(unit,interval,datetime_expr)
TIMESTAMPDIFF()
TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)
TIME_FORMAT(time,format)
TIME_TO_SEC(time)
TO_DAYS()
TO_DAYS(date)
TO_DAYS(date_col)
TO_SECONDS()
TO_SECONDS(expr)
TRIM([remstr FROM] str)
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str)
TRUNCATE()
TRUNCATE(X,D)
UCASE(str)
UNCOMPRESS()
UNCOMPRESS(string_to_uncompress)
UNCOMPRESSED_LENGTH()
UNCOMPRESSED_LENGTH(compressed_string)
UNHEX()
UNHEX(str)
UNIX_TIMESTAMP()
UNIX_TIMESTAMP(date)
UNIX_TIMESTAMP(timestamp_column)
UPPER()
UPPER(X)
UPPER(_utf8'abc')
UPPER(str)
USER()
- Section 5.5.8, “Auditing MySQL Account Activity”
- Section 5.4.7, “Causes of Access-Denied Errors”
- Section 9.1.7.4, “Collation of Expressions”
- Section 9.1.7.3, “Collations Must Be for the Right Character Set”
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 11.11.3, “Information Functions”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.11, “Replication and System Functions”
- Section 9.1.11, “UTF-8 for Metadata”
UTC_DATE()
UTC_TIME()
UTC_TIMESTAMP()
UUID()
- Section 16.1.3.4, “Binary Log Options and Variables”
- Section 19.7, “Binary Logging of Stored Programs”
- Section 7.5.5.1, “How the Query Cache Operates”
- Section 11.11.4, “Miscellaneous Functions”
- Section 5.2.4.3, “Mixed Binary Logging Format”
- Section 16.4.1.11, “Replication and System Functions”
- Section 5.2.4.2, “Setting The Binary Log Format”
UUID_SHORT()
Union(g1,g2)
UpdateXML(xml_target, xpath_expr, new_xml)
VALUES()
VALUES(col_name)
VARIANCE(expr)
VAR_POP(expr)
VAR_SAMP(expr)
VERSION()
WEEK(date)
WEEK(date,0)
WEEK(date,3)
WEEK(date[,mode])
WEEKDAY()
WEEKDAY(date)
WEEKOFYEAR()
WEEKOFYEAR(date)
WEIGHT_STRING()
WEIGHT_STRING(str [AS {CHAR|BINARY}(N)] [LEVEL levels] [flags])
WEIGHT_STRING(str1)
WEIGHT_STRING(str2)
YEAR('1984-06-21')
YEAR('1999-06-21')
YEAR()
YEAR(date)
YEAR(date_col)
YEAR(separated)
YEARWEEK()
YEARWEEK(date)
YEARWEEK(date,mode)
addslashes()
crypt()
expr IN (value,...)
expr NOT IN (value,...)
gethostbyaddr()
gethostbyaddr_r()
gethostbyname()
gethostbyname_r()
handle_option()
my_open()
my_strxfrm_MYSET()
mysql_bind_param()
mysql_bind_result()
mysql_escape_string()
mysql_execute()
mysql_fetch_column()
mysql_get_metadata()
mysql_library_xxx()
mysql_list_tables()
mysql_param_count()
mysql_param_result()
mysql_prepare()
mysql_real_escape_string()
mysql_send_long_data()
mysql_shutdown(X)
mysql_shutdown(X,SHUTDOWN_DEFAULT)
pthread_exit()
setrlimit()
thr_setconcurrency()