MySQL 5.6 Release Notes
Symbols | A | B | C | D | E | F | G | H | I | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y
ABS()
ADDDATE()
ADDTIME()
AES_DECRYPT()
AES_ENCRYPT()
AsBinary()
AsText()
ASYMMETRIC_DECRYPT()
ASYMMETRIC_DERIVE()
ASYMMETRIC_ENCRYPT()
ASYMMETRIC_SIGN()
ASYMMETRIC_VERIFY()
AVG()
BENCHMARK()
BIT_AND()
BIT_COUNT()
BIT_LENGTH()
BIT_OR()
BIT_XOR()
CAST()
- Section 9.1.5, “Bit-Value Literals”
- Section 12.10, “Cast Functions and Operators”
- Section 12.7.3, “Character Set and Collation of Function Results”
- Section 12.3.2, “Comparison Functions and Operators”
- Section 11.2.8, “Conversion Between Date and Time Types”
- Section 12.6, “Date and Time Functions”
- Section 9.5, “Expressions”
- Section 9.1.4, “Hexadecimal Literals”
- Section 1.8.2, “MySQL Differences from Standard SQL”
- Section 12.2, “Type Conversion in Expression Evaluation”
- Section 9.4, “User-Defined Variables”
CEILING()
CHAR()
CHAR_LENGTH()
CHARACTER_LENGTH()
CHARSET()
COERCIBILITY()
COLLATION()
COMPRESS()
CONCAT()
- Section 12.19.1, “Aggregate Function Descriptions”
- Section 12.10, “Cast Functions and Operators”
- Section 12.7.3, “Character Set and Collation of Function Results”
- Section 10.2.1, “Character Set Repertoire”
- Section 10.8.4, “Collation Coercibility in Expressions”
- Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
- Section 12.3.3, “Logical Operators”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 5.1.10, “Server SQL Modes”
- Section 13.7.5.14, “SHOW CREATE VIEW Statement”
- Section 12.7, “String Functions and Operators”
- Section 21.29, “The INFORMATION_SCHEMA VIEWS Table”
- Section 12.2, “Type Conversion in Expression Evaluation”
- Section 12.11, “XML Functions”
CONCAT_WS()
CONNECTION_ID()
- Section 6.4.4.3, “Audit Log File Formats”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.15, “Information Functions”
- Section 13.7.6.4, “KILL Statement”
- Section 13.7.5.30, “SHOW PROCESSLIST Statement”
- Section 21.16, “The INFORMATION_SCHEMA PROCESSLIST Table”
- Section 22.12.10.3, “The threads Table”
Contains()
CONV()
CONVERT()
- Section 12.10, “Cast Functions and Operators”
- Section 10.3.8, “Character Set Introducers”
- Section 10.3.6, “Character String Literal Character Set and Collation”
- Section 12.3.2, “Comparison Functions and Operators”
- Section A.11, “MySQL 5.6 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 4.5.1.1, “mysql Client Options”
CONVERT_TZ()
COUNT()
- Section 12.19.1, “Aggregate Function Descriptions”
- Section 3.3.4.8, “Counting Rows”
- Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
- Section 8.2.1.14, “GROUP BY Optimization”
- Section 14.23, “InnoDB Restrictions and Limitations”
- Section 8.4.4, “Internal Temporary Table Use in MySQL”
- Section 18.1.7.3, “Limits Relating to Transaction Handling in NDB Cluster”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 18.3.3.8.3, “NDB Cluster Status Variables”
- Section B.4.4.3, “Problems with NULL Values”
- Section 5.1.10, “Server SQL Modes”
- Section 1.3.2, “The Main Features of MySQL”
- Section 20.5.3, “Updatable and Insertable Views”
- Section 20.5.2, “View Processing Algorithms”
- Section 8.2.1.1, “WHERE Clause Optimization”
CREATE_ASYMMETRIC_PRIV_KEY()
CREATE_ASYMMETRIC_PUB_KEY()
CREATE_DH_PARAMETERS()
crypt()
CURDATE()
CURRENT_DATE()
CURRENT_TIME
CURRENT_TIME()
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP()
CURRENT_USER
- Section 13.7.1.1, “ALTER USER Statement”
- Section 13.1.11, “CREATE EVENT Statement”
- Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
- Section 13.1.19, “CREATE TRIGGER Statement”
- Section 13.1.20, “CREATE VIEW Statement”
- Section 6.2.3, “Grant Tables”
- Section 12.15, “Information Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.15, “Replication and System Functions”
- Section 17.4.1.8, “Replication of CURRENT_USER()”
- Section 6.2.4, “Specifying Account Names”
- Section 20.6, “Stored Object Access Control”
CURRENT_USER()
- Section 6.2.5, “Access Control, Stage 1: Connection Verification”
- Section 13.7.1.1, “ALTER USER Statement”
- Section 6.4.2.1, “Connection-Control Plugin Installation”
- Section 13.1.11, “CREATE EVENT Statement”
- Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
- Section 13.1.19, “CREATE TRIGGER Statement”
- Section 13.1.20, “CREATE VIEW Statement”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 24.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
- Section 12.15, “Information Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 6.2.12, “Proxy Users”
- Section 17.4.1.15, “Replication and System Functions”
- Section 17.4.1.8, “Replication of CURRENT_USER()”
- Section 13.7.1.7, “SET PASSWORD Statement”
- Section 6.2.4, “Specifying Account Names”
- Section 6.2.15, “SQL-Based Account Activity Auditing”
- Section 20.6, “Stored Object Access Control”
- Section 10.2.2, “UTF-8 for Metadata”
- Section 24.2.4.9.1, “Writing the Server-Side Authentication Plugin”
CURTIME()
- Section 12.6, “Date and Time Functions”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 11.2.7, “Fractional Seconds in Time Values”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 5.1.13, “MySQL Server Time Zone Support”
- Section 17.4.1.14, “Replication and Fractional Seconds Support”
DATABASE()
- Section 17.1.4.4, “Binary Log Options and Variables”
- Section 3.3.1, “Creating and Selecting a Database”
- Section 13.1.21, “DROP DATABASE Statement”
- Section 3.4, “Getting Information About Databases and Tables”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.15, “Information Functions”
- Section B.4.7, “Known Issues in MySQL”
- Section 10.2.2, “UTF-8 for Metadata”
DATE_ADD()
DATE_FORMAT()
DATE_SUB()
DATEDIFF()
DAY()
DAYNAME()
DAYOFMONTH()
DAYOFWEEK()
DAYOFYEAR()
DECODE()
DEFAULT()
DEGREES()
DES_DECRYPT()
DES_ENCRYPT()
ELT()
ENCODE()
ENCRYPT()
EXPORT_SET()
EXTRACT()
ExtractValue()
FLOOR()
FORMAT()
FOUND_ROWS()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.15, “Information Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.15, “Replication and System Functions”
FROM_BASE64()
FROM_DAYS()
FROM_UNIXTIME()
GeomCollFromText()
GeomCollFromWKB()
GeometryCollection()
GeometryCollectionFromText()
GeometryCollectionFromWKB()
GeometryFromText()
GeometryFromWKB()
GeometryType()
GeomFromText()
GET_LOCK()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 23.7.19, “C API Automatic Reconnection Control”
- Section 13.1.11, “CREATE EVENT Statement”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 20.4.1, “Event Scheduler Overview”
- Section 8.14.2, “General Thread States”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 8.11.1, “Internal Locking Methods”
- Section 13.7.6.4, “KILL Statement”
- Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
- Section 12.14, “Locking Functions”
- Section 23.7.6.3, “mysql_change_user()”
- Section 17.4.1.15, “Replication and System Functions”
gethostbyaddr()
gethostbyname()
gettimeofday()
GLength()
GREATEST()
GROUP_CONCAT()
GTID_SUBSET()
GTID_SUBTRACT()
HEX()
- Section 9.1.5, “Bit-Value Literals”
- Section 12.7.3, “Character Set and Collation of Function Results”
- Section 10.3.6, “Character String Literal Character Set and Collation”
- Section 9.1.4, “Hexadecimal Literals”
- Section 12.5.2, “Mathematical Functions”
- Section 12.20, “Miscellaneous Functions”
- Section A.11, “MySQL 5.6 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 12.7, “String Functions and Operators”
HOUR()
IF()
INSTR()
InteriorRingN()
IS_FREE_LOCK()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.14, “Locking Functions”
- Section 17.4.1.15, “Replication and System Functions”
IS_IPV4()
IS_IPV4_COMPAT()
IS_IPV4_MAPPED()
IS_IPV6()
IS_USED_LOCK()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.14, “Locking Functions”
- Section 17.4.1.15, “Replication and System Functions”
LAST_DAY()
LAST_INSERT_ID()
- Section 23.7.19, “C API Automatic Reconnection Control”
- Section 12.3.2, “Comparison Functions and Operators”
- Section 13.1.17, “CREATE TABLE Statement”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 23.7.20.3, “How to Get the Unique ID for the Last Inserted Row”
- Section 12.15, “Information Functions”
- Section 13.2.5.2, “INSERT ... ON DUPLICATE KEY UPDATE Statement”
- Section 13.2.5.3, “INSERT DELAYED Statement”
- Section 13.2.5, “INSERT Statement”
- Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 23.7.6.37, “mysql_insert_id()”
- Section 23.7.10.16, “mysql_stmt_insert_id()”
- Section 17.4.1.1, “Replication and AUTO_INCREMENT”
- Section 17.4.1.15, “Replication and System Functions”
- Section 5.1.7, “Server System Variables”
- Section 20.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
- Section 17.4.4, “Troubleshooting Replication”
- Section 20.5.3, “Updatable and Insertable Views”
- Section 3.6.9, “Using AUTO_INCREMENT”
LCASE()
LEAST()
LENGTH()
Length()
LineStringFromText()
LineStringFromWKB()
LOAD_FILE()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 13.2.7, “LOAD XML Statement”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 12.18.2, “MySQL Enterprise Encryption Usage and Examples”
- Section 6.2.2, “Privileges Provided by MySQL”
- Section 17.4.1.15, “Replication and System Functions”
- Section 5.1.7, “Server System Variables”
- Section 12.7, “String Functions and Operators”
LOCALTIME
LOCALTIME()
LOCALTIMESTAMP
LOCALTIMESTAMP()
LOWER()
LTRIM()
MAKEDATE()
MAKETIME()
MASTER_POS_WAIT()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.20, “Miscellaneous Functions”
- Section A.14, “MySQL 5.6 FAQ: Replication”
MATCH()
- Section 12.9.2, “Boolean Full-Text Searches”
- Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”
- Section 12.9.5, “Full-Text Restrictions”
- Section 12.9, “Full-Text Search Functions”
- Section 14.6.2.3, “InnoDB FULLTEXT Indexes”
- MySQL Glossary
- Section 12.9.1, “Natural Language Full-Text Searches”
- Section 1.4, “What Is New in MySQL 5.6”
MAX()
- Section 11.2.9, “2-Digit Years in Dates”
- Section 12.19.1, “Aggregate Function Descriptions”
- Section 8.2.1.14, “GROUP BY Optimization”
- Section 8.3.1, “How MySQL Uses Indexes”
- Section B.4.7, “Known Issues in MySQL”
- Section 11.1.1, “Numeric Data Type Syntax”
- Section 13.2.10.10, “Optimizing Subqueries”
- Section 5.1.10, “Server SQL Modes”
- Section 21.32.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
- Section 1.3.2, “The Main Features of MySQL”
- Section 20.5.3, “Updatable and Insertable Views”
- Section 8.3.9, “Use of Index Extensions”
- Section 3.6.9, “Using AUTO_INCREMENT”
- Section 20.5.2, “View Processing Algorithms”
MBRContains()
MBRIntersects()
MBRWithin()
MD5()
MICROSECOND()
MID()
MIN()
- Section 11.2.9, “2-Digit Years in Dates”
- Section 12.19.1, “Aggregate Function Descriptions”
- Section 23.7.18, “C API Prepared Statement Problems”
- Section 8.2.1.14, “GROUP BY Optimization”
- Section 8.3.1, “How MySQL Uses Indexes”
- Section B.4.7, “Known Issues in MySQL”
- Section 11.1.1, “Numeric Data Type Syntax”
- Section 13.2.10.10, “Optimizing Subqueries”
- Section B.4.4.3, “Problems with NULL Values”
- Section 1.3.2, “The Main Features of MySQL”
- Section 20.5.3, “Updatable and Insertable Views”
- Section 8.3.9, “Use of Index Extensions”
- Section 20.5.2, “View Processing Algorithms”
- Section 8.2.1.1, “WHERE Clause Optimization”
MINUTE()
MOD()
MONTH()
MONTHNAME()
MultiLineString()
MultiLineStringFromText()
MultiLineStringFromWKB()
MultiPointFromText()
MultiPointFromWKB()
MultiPolygonFromText()
MultiPolygonFromWKB()
my_open()
NOW()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 11.2.6, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
- Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
- Section 11.5, “Data Type Default Values”
- Section 12.6, “Date and Time Functions”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 11.2.7, “Fractional Seconds in Time Values”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section A.1, “MySQL 5.6 FAQ: General”
- Section 5.1.13, “MySQL Server Time Zone Support”
- Section 17.4.1.15, “Replication and System Functions”
- Section 17.4.1.31, “Replication and Time Zones”
- Section 5.1.6, “Server Command Options”
- Section 5.1.7, “Server System Variables”
- Section 11.2.4, “The YEAR Type”
NumGeometries()
NumInteriorRings()
OCTET_LENGTH()
OLD_PASSWORD()
- Section 2.11.3, “Changes in MySQL 5.6”
- Section B.4.2.4, “Client does not support authentication protocol”
- Section 13.7.1.2, “CREATE USER Statement”
- Section 12.13, “Encryption and Compression Functions”
- Section 6.1.2.5, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
- Section 6.1.2.4, “Password Hashing in MySQL”
- Section 5.1.7, “Server System Variables”
- Section 13.7.1.7, “SET PASSWORD Statement”
- Section 6.4.3, “The Password Validation Plugin”
- Section 24.2.1, “Types of Plugins”
- Section 1.4, “What Is New in MySQL 5.6”
PASSWORD()
- Section 6.2.5, “Access Control, Stage 1: Connection Verification”
- Section 6.2.9, “Assigning Account Passwords”
- Section 2.11.3, “Changes in MySQL 5.6”
- Section 13.7.1.2, “CREATE USER Statement”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 12.13, “Encryption and Compression Functions”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section B.4.2.15, “Ignoring user”
- Section 6.1.2.5, “Implications of Password Hashing Changes in MySQL 4.1 for Application Programs”
- Section 19.2.5, “KEY Partitioning”
- Section 1.8.1, “MySQL Extensions to Standard SQL”
- Section 6.1.2.4, “Password Hashing in MySQL”
- Section 6.1.2.3, “Passwords and Logging”
- Section 5.1.7, “Server System Variables”
- Section 13.7.1.7, “SET PASSWORD Statement”
- Section 6.4.1.4, “SHA-256 Pluggable Authentication”
- Section 6.4.3, “The Password Validation Plugin”
- Section 6.2.14, “Troubleshooting Problems Connecting to MySQL”
- Section 24.2.1, “Types of Plugins”
- Section 1.4, “What Is New in MySQL 5.6”
PERIOD_ADD()
PERIOD_DIFF()
Point()
PolygonFromText()
POW()
pthread_mutex()
QUARTER()
QUOTE()
RADIANS()
RAND()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Statements”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.2.1.17, “Function Call Optimization”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.5.2, “Mathematical Functions”
- Section 17.4.1.15, “Replication and System Functions”
- Section 5.1.7, “Server System Variables”
RANDOM_BYTES()
RELEASE_ALL_LOCKS()
RELEASE_LOCK()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 13.2.3, “DO Statement”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 8.11.1, “Internal Locking Methods”
- Section 13.3.5, “LOCK TABLES and UNLOCK TABLES Statements”
- Section 12.14, “Locking Functions”
- Section 17.4.1.15, “Replication and System Functions”
REPEAT()
REPLACE()
REVERSE()
RIGHT()
ROUND()
ROW_COUNT()
- Section 13.2.1, “CALL Statement”
- Section 13.2.2, “DELETE Statement”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 12.15, “Information Functions”
- Section 13.2.5, “INSERT Statement”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 23.7.6.1, “mysql_affected_rows()”
- Section 17.4.1.15, “Replication and System Functions”
- Section 13.6.7.7, “The MySQL Diagnostics Area”
RPAD()
RTRIM()
SEC_TO_TIME()
SECOND()
SESSION_USER()
setrlimit()
SHA1()
SHA2()
SLEEP()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.14.2, “General Thread States”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.20, “Miscellaneous Functions”
- Section 21.32.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”
SOUNDEX()
SPACE()
SQL_THREAD_WAIT_AFTER_GTIDS()
ST_Area()
ST_AsBinary()
ST_Buffer()
ST_Contains()
ST_Difference()
ST_Dimension()
ST_EndPoint()
ST_Envelope()
ST_ExteriorRing()
ST_GeomCollFromText()
ST_GeomCollFromWKB()
ST_GeometryCollectionFromText()
ST_GeometryCollectionFromWKB()
ST_GeometryFromText()
ST_GeometryFromWKB()
ST_GeometryN()
ST_GeometryType()
ST_GeomFromText()
ST_InteriorRingN()
ST_Intersection()
ST_IsSimple()
ST_LineFromText()
ST_LineStringFromText()
ST_LineStringFromWKB()
ST_NumGeometries()
ST_NumInteriorRings()
ST_PointFromText()
ST_PointFromWKB()
ST_PointN()
ST_PolyFromText()
ST_PolygonFromText()
ST_PolygonFromWKB()
ST_SymDifference()
ST_X()
StartPoint()
STD()
STDDEV_POP()
STDDEV_SAMP()
STR_TO_DATE()
STRCMP()
SUBDATE()
SUBSTRING()
SUBSTRING_INDEX()
SUBTIME()
SUM()
- Section 24.4.2, “Adding a User-Defined Function”
- Section 12.19.1, “Aggregate Function Descriptions”
- Section 11.2.1, “Date and Time Data Type Syntax”
- Section 8.2.1.14, “GROUP BY Optimization”
- Section B.4.4.3, “Problems with NULL Values”
- Section 11.3.5, “The ENUM Type”
- Section 1.3.2, “The Main Features of MySQL”
- Section 11.3.6, “The SET Type”
- Section 20.5.3, “Updatable and Insertable Views”
- Section 20.5.2, “View Processing Algorithms”
SYSDATE()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 12.6, “Date and Time Functions”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 11.2.7, “Fractional Seconds in Time Values”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 17.4.1.14, “Replication and Fractional Seconds Support”
- Section 17.4.1.15, “Replication and System Functions”
- Section 5.1.6, “Server Command Options”
- Section 5.1.7, “Server System Variables”
SYSTEM_USER()
thr_setconcurrency()
TIME_TO_SEC()
TIMEDIFF()
TIMESTAMP()
TIMESTAMPADD()
TO_BASE64()
TO_DAYS()
TO_SECONDS()
TRIM()
TRUNCATE()
UCASE()
UNCOMPRESS()
UNCOMPRESSED_LENGTH()
UNHEX()
UNIX_TIMESTAMP()
- Section 12.6, “Date and Time Functions”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 8.3.10, “Indexed Lookups from TIMESTAMP Columns”
- Section 19.6.3, “Partitioning Limitations Relating to Functions”
- Section 19.2.1, “RANGE Partitioning”
- Section 5.1.7, “Server System Variables”
- Section B.4.3.7, “Time Zone Problems”
UpdateXML()
UPPER()
- Section 12.10, “Cast Functions and Operators”
- Section 12.7.3, “Character Set and Collation of Function Results”
- Section 10.2.1, “Character Set Repertoire”
- Section 12.7, “String Functions and Operators”
- Section 10.10.1, “Unicode Character Sets”
- Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches”
USER()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 10.8.4, “Collation Coercibility in Expressions”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 24.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”
- Section 12.15, “Information Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 6.2.12, “Proxy Users”
- Section 17.4.1.15, “Replication and System Functions”
- Section 6.2.15, “SQL-Based Account Activity Auditing”
- Section 10.2.2, “UTF-8 for Metadata”
- Section 24.2.4.9.1, “Writing the Server-Side Authentication Plugin”
UTC_DATE()
UTC_TIME()
UTC_TIMESTAMP
UTC_TIMESTAMP()
UUID()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 17.1.4.4, “Binary Log Options and Variables”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 8.2.1.17, “Function Call Optimization”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.20, “Miscellaneous Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.15, “Replication and System Functions”
- Section 5.4.4.2, “Setting The Binary Log Format”
- Section 20.7, “Stored Program Binary Logging”
UUID_SHORT()
VALIDATE_PASSWORD_STRENGTH()
VALUES()
VERSION()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 6.4.4.3, “Audit Log File Formats”
- Section B.4.4.1, “Case Sensitivity in String Searches”
- Section 10.8.4, “Collation Coercibility in Expressions”
- Section 12.15, “Information Functions”
- Section 17.4.1.15, “Replication and System Functions”
- Section 10.2.2, “UTF-8 for Metadata”
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
WEEKDAY()
WEEKOFYEAR()
WEIGHT_STRING()
YEAR()
- Section 12.6, “Date and Time Functions”
- Section 3.3.4.5, “Date Calculations”
- Section 19.2.4, “HASH Partitioning”
- Section 19.2.7, “How MySQL Partitioning Handles NULL”
- Section 19.3.1, “Management of RANGE and LIST Partitions”
- Section 19.4, “Partition Pruning”
- Section 19.6.3, “Partitioning Limitations Relating to Functions”
- Section 19.2, “Partitioning Types”
- Section 19.2.1, “RANGE Partitioning”