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.5.3, “Character Set and Collation of Function Results”
- Section 12.3.2, “Comparison Functions and Operators”
- Section 11.3.7, “Conversion Between Date and Time Types”
- Section 12.7, “Date and Time Functions”
- Section 9.1.4, “Hexadecimal Literals”
- Section 1.7.2, “MySQL Differences from Standard SQL”
- Section 11.3.1, “The DATE, DATETIME, and TIMESTAMP Types”
- Section 12.2, “Type Conversion in Expression Evaluation”
- Section 9.4, “User-Defined Variables”
CEILING()
CHAR()
CHARACTER_LENGTH()
CHARSET()
COERCIBILITY()
COLLATION()
COMPRESS()
CONCAT()
- Section 12.18.1, “Aggregate (GROUP BY) Function Descriptions”
- Section 12.10, “Cast Functions and Operators”
- Section 12.5.3, “Character Set and Collation of Function Results”
- Section 10.1.2.1, “Character Set Repertoire”
- Section 10.1.8.4, “Collation Coercibility in Expressions”
- Section 13.7.3.1, “CREATE FUNCTION Syntax for User-Defined Functions”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 5.1.8, “Server SQL Modes”
- Section 13.7.5.14, “SHOW CREATE VIEW Syntax”
- Section 12.5, “String Functions”
- Section 21.28, “The INFORMATION_SCHEMA VIEWS Table”
- Section 12.2, “Type Conversion in Expression Evaluation”
- Section 12.11, “XML Functions”
CONCAT_WS()
CONNECTION_ID()
- 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, “Information Functions”
- Section 13.7.6.4, “KILL Syntax”
- Section 13.7.5.30, “SHOW PROCESSLIST Syntax”
- Section 6.5.4.3, “The Audit Log File”
- Section 22.11.10.3, “The threads Table”
Contains()
CONV()
CONVERT()
CONVERT_TZ()
COUNT()
- Section 12.18.1, “Aggregate (GROUP BY) 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 8.4.4, “Internal Temporary Table Use in MySQL”
- Section 18.1.6.3, “Limits Relating to Transaction Handling in NDB Cluster”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 19.1, “Overview of Partitioning in MySQL”
- Section B.5.4.3, “Problems with NULL Values”
- Section 5.1.8, “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()
CREATE_DIGEST()
crypt()
CURDATE()
CURRENT_DATE
CURRENT_DATE()
CURRENT_TIME
CURRENT_TIME()
CURRENT_TIMESTAMP
CURRENT_TIMESTAMP()
CURRENT_USER
- Section 20.6, “Access Control for Stored Programs and Views”
- Section 13.7.1.1, “ALTER USER Syntax”
- Section 13.1.11, “CREATE EVENT Syntax”
- Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
- Section 13.1.19, “CREATE TRIGGER Syntax”
- Section 13.1.20, “CREATE VIEW Syntax”
- Section 6.2.2, “Grant Tables”
- Section 12.14, “Information Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.16, “Replication and System Functions”
- Section 17.4.1.8, “Replication of CURRENT_USER()”
- Section 6.2.3, “Specifying Account Names”
CURRENT_USER()
- Section 6.2.4, “Access Control, Stage 1: Connection Verification”
- Section 13.7.1.1, “ALTER USER Syntax”
- Section 6.5.2.1, “Connection-Control Plugin Installation”
- Section 13.1.11, “CREATE EVENT Syntax”
- Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
- Section 13.1.19, “CREATE TRIGGER Syntax”
- Section 13.1.20, “CREATE VIEW Syntax”
- 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.14, “Information Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 6.3.8, “Proxy Users”
- Section 17.4.1.16, “Replication and System Functions”
- Section 17.4.1.8, “Replication of CURRENT_USER()”
- Section 13.7.1.7, “SET PASSWORD Syntax”
- Section 6.2.3, “Specifying Account Names”
- Section 6.3.9, “SQL-Based MySQL Account Activity Auditing”
- Section 10.1.2.2, “UTF-8 for Metadata”
- Section 24.2.4.9.1, “Writing the Server-Side Authentication Plugin”
CURTIME()
- Section 12.7, “Date and Time Functions”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 11.3.6, “Fractional Seconds in Time Values”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 10.6, “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 Syntax”
- Section 3.4, “Getting Information About Databases and Tables”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 12.14, “Information Functions”
- Section B.5.7, “Known Issues in MySQL”
- Section 10.1.2.2, “UTF-8 for Metadata”
DATE_ADD()
DATE_FORMAT()
DATEDIFF()
DAY()
DAYNAME()
DAYOFMONTH()
DAYOFWEEK()
DAYOFYEAR()
DECODE()
DEFAULT()
DEGREES()
DES_DECRYPT()
DES_ENCRYPT()
Disjoint()
ELT()
ENCODE()
ENCRYPT()
Equals()
EXPORT_SET()
expr NOT IN ()
EXTRACT()
ExtractValue()
FIELD()
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.14, “Information Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.16, “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.8.16, “Controlling Automatic Reconnection Behavior”
- Section 13.1.11, “CREATE EVENT Syntax”
- 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 Syntax”
- Section 12.19, “Miscellaneous Functions”
- Section 23.8.7.3, “mysql_change_user()”
- Section 17.4.1.16, “Replication and System Functions”
- Section 13.3.5.3, “Table-Locking Restrictions and Conditions”
gethostbyaddr()
gethostbyaddr_r()
gethostbyname()
gethostbyname_r()
gettimeofday()
GLength()
GREATEST()
GROUP_CONCAT()
GTID_SUBSET()
GTID_SUBTRACT()
HEX()
- Section 9.1.5, “Bit-Value Literals”
- Section 12.5.3, “Character Set and Collation of Function Results”
- Section 10.1.3.6, “Character String Literal Character Set and Collation”
- Section 9.1.4, “Hexadecimal Literals”
- Section 12.6.2, “Mathematical Functions”
- Section 12.19, “Miscellaneous Functions”
- Section A.11, “MySQL 5.6 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
- Section 12.5, “String Functions”
HOUR()
IF()
IN()
INSERT()
INSTR()
InteriorRingN()
Intersects()
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.19, “Miscellaneous Functions”
- Section 17.4.1.16, “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.19, “Miscellaneous Functions”
- Section 17.4.1.16, “Replication and System Functions”
LAST_DAY()
LAST_INSERT_ID()
- Section 12.3.2, “Comparison Functions and Operators”
- Section 23.8.16, “Controlling Automatic Reconnection Behavior”
- Section 13.1.17, “CREATE TABLE Syntax”
- 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.8.15.3, “How to Get the Unique ID for the Last Inserted Row”
- Section 12.14, “Information Functions”
- Section 13.2.5.3, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”
- Section 13.2.5.2, “INSERT DELAYED Syntax”
- Section 13.2.5, “INSERT Syntax”
- Section 1.7.1, “MySQL Extensions to Standard SQL”
- Section 23.8.7.37, “mysql_insert_id()”
- Section 23.8.11.16, “mysql_stmt_insert_id()”
- Section 4.6.8.1, “mysqlbinlog Hex Dump Format”
- Section 17.4.1.1, “Replication and AUTO_INCREMENT”
- Section 17.4.1.16, “Replication and System Functions”
- Section 5.1.5, “Server System Variables”
- Section 20.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”
- Section 13.3.5.3, “Table-Locking Restrictions and Conditions”
- 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 12.17.2, “Enterprise Encryption Usage and Examples”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 13.2.7, “LOAD XML Syntax”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 6.2.1, “Privileges Provided by MySQL”
- Section 17.4.1.16, “Replication and System Functions”
- Section 5.1.4, “Server Command Options”
- Section 5.1.5, “Server System Variables”
- Section 12.5, “String Functions”
LOCALTIME
LOCALTIME()
LOCALTIMESTAMP
LOCALTIMESTAMP()
LOCATE()
LOWER()
LTRIM()
MAKE_SET()
MAKEDATE()
MAKETIME()
MASTER_POS_WAIT()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 13.4.2.1, “CHANGE MASTER TO Syntax”
- 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.19, “Miscellaneous Functions”
- Section A.13, “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.8.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 12.18.1, “Aggregate (GROUP BY) Function Descriptions”
- Section 8.2.1.14, “GROUP BY Optimization”
- Section 8.3.1, “How MySQL Uses Indexes”
- Section B.5.7, “Known Issues in MySQL”
- Section 11.1.1, “Numeric Type Overview”
- Section 13.2.10.10, “Optimizing Subqueries”
- Section 5.1.8, “Server SQL Modes”
- Section 21.31.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”
- Section 1.3.2, “The Main Features of MySQL”
- Section 11.3.8, “Two-Digit Years in Dates”
- 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()
MBRDisjoint()
MBRIntersects()
MBROverlaps()
MBRTouches()
MBRWithin()
MD5()
MICROSECOND()
MID()
MIN()
- Section 12.18.1, “Aggregate (GROUP BY) Function Descriptions”
- Section 23.8.18, “C API Prepared Statement Problems”
- Section 8.2.1.14, “GROUP BY Optimization”
- Section 8.3.1, “How MySQL Uses Indexes”
- Section B.5.7, “Known Issues in MySQL”
- Section 11.1.1, “Numeric Type Overview”
- Section 13.2.10.10, “Optimizing Subqueries”
- Section B.5.4.3, “Problems with NULL Values”
- Section 1.3.2, “The Main Features of MySQL”
- Section 11.3.8, “Two-Digit Years in Dates”
- 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()
NAME_CONST()
NOW()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”
- Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”
- Section 13.1.17, “CREATE TABLE Syntax”
- Section 11.6, “Data Type Default Values”
- Section 12.7, “Date and Time Functions”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 11.3.6, “Fractional Seconds in Time Values”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section A.1, “MySQL 5.6 FAQ: General”
- Section 10.6, “MySQL Server Time Zone Support”
- Section 17.4.1.16, “Replication and System Functions”
- Section 17.4.1.32, “Replication and Time Zones”
- Section 5.1.4, “Server Command Options”
- Section 5.1.5, “Server System Variables”
- Section 11.3.3, “The YEAR Type”
- Section 10.6.2, “Time Zone Leap Second Support”
NumGeometries()
NumInteriorRings()
OCTET_LENGTH()
OLD_PASSWORD()
- Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.6”
- Section B.5.2.4, “Client does not support authentication protocol”
- Section 13.7.1.2, “CREATE USER Syntax”
- 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.5, “Server System Variables”
- Section 13.7.1.7, “SET PASSWORD Syntax”
- Section 6.5.3, “The Password Validation Plugin”
- Section 24.2.1, “Types of Plugins”
- Section 1.4, “What Is New in MySQL 5.6”
Overlaps()
PASSWORD()
- Section 6.2.4, “Access Control, Stage 1: Connection Verification”
- Section 6.3.5, “Assigning Account Passwords”
- Section 2.11.1.1, “Changes Affecting Upgrades to MySQL 5.6”
- Section 13.7.1.2, “CREATE USER Syntax”
- 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.5.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.7.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.4, “Server Command Options”
- Section 5.1.5, “Server System Variables”
- Section 13.7.1.7, “SET PASSWORD Syntax”
- Section 6.5.1.4, “SHA-256 Pluggable Authentication”
- Section 6.5.3, “The Password Validation Plugin”
- Section 6.2.7, “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()
POSITION()
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 Syntax”
- 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.6.2, “Mathematical Functions”
- Section 4.6.8.1, “mysqlbinlog Hex Dump Format”
- Section 17.4.1.16, “Replication and System Functions”
- Section 5.1.5, “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 Syntax”
- Section 8.10.3.1, “How the Query Cache Operates”
- Section 8.11.1, “Internal Locking Methods”
- Section 12.19, “Miscellaneous Functions”
- Section 17.4.1.16, “Replication and System Functions”
- Section 13.3.5.3, “Table-Locking Restrictions and Conditions”
REPEAT()
REPLACE()
REVERSE()
RIGHT()
ROUND()
ROW_COUNT()
- Section 13.2.1, “CALL Syntax”
- Section 13.2.2, “DELETE Syntax”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 13.6.7.7.2, “Diagnostics Area Information Items”
- Section 12.14, “Information Functions”
- Section 13.2.5, “INSERT Syntax”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 23.8.7.1, “mysql_affected_rows()”
- Section 17.4.1.16, “Replication and System Functions”
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.19, “Miscellaneous Functions”
- Section 17.4.1, “Replication Features and Issues”
- Section 21.31.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()
STRCMP()
SUBDATE()
SUBSTR()
SUBSTRING()
SUBSTRING_INDEX()
SUBTIME()
SUM()
- Section 24.4.2, “Adding a New User-Defined Function”
- Section 12.18.1, “Aggregate (GROUP BY) Function Descriptions”
- Section 11.1.2, “Date and Time Type Overview”
- Section 8.2.1.14, “GROUP BY Optimization”
- Section 19.1, “Overview of Partitioning in MySQL”
- Section B.5.4.3, “Problems with NULL Values”
- Section 11.4.4, “The ENUM Type”
- Section 1.3.2, “The Main Features of MySQL”
- Section 11.4.5, “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.7, “Date and Time Functions”
- Section 17.1.2.3, “Determination of Safe and Unsafe Statements in Binary Logging”
- Section 11.3.6, “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.16, “Replication and System Functions”
- Section 5.1.4, “Server Command Options”
- Section 5.1.5, “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()
UNIX_TIMESTAMP()
- Section 12.7, “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 19.6.3, “Partitioning Limitations Relating to Functions”
- Section 19.2.1, “RANGE Partitioning”
- Section 5.1.5, “Server System Variables”
- Section B.5.3.7, “Time Zone Problems”
UpdateXML()
UPPER()
USER()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section 10.1.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.14, “Information Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 6.3.8, “Proxy Users”
- Section 17.4.1.16, “Replication and System Functions”
- Section 6.3.9, “SQL-Based MySQL Account Activity Auditing”
- Section 10.1.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 20.7, “Binary Logging of Stored Programs”
- 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.19, “Miscellaneous Functions”
- Section 5.4.4.3, “Mixed Binary Logging Format”
- Section 17.4.1.16, “Replication and System Functions”
- Section 5.4.4.2, “Setting The Binary Log Format”
UUID_SHORT()
VALIDATE_PASSWORD_STRENGTH()
VALUES()
VERSION()
- Section 17.1.2.1, “Advantages and Disadvantages of Statement-Based and Row-Based Replication”
- Section B.5.4.1, “Case Sensitivity in String Searches”
- Section 10.1.8.4, “Collation Coercibility in Expressions”
- Section 12.14, “Information Functions”
- Section 17.4.1.16, “Replication and System Functions”
- Section 6.5.4.3, “The Audit Log File”
- Section 10.1.2.2, “UTF-8 for Metadata”
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()
WEEKDAY()
WEEKOFYEAR()
WEIGHT_STRING()
Within()
YEAR()
- Section 12.7, “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”