PDF (US Ltr)
- 3.0Mb
PDF (A4)
- 3.0Mb
HTML Download (TGZ)
- 119.1Kb
HTML Download (Zip)
- 121.2Kb
The following table shows all functions and operators available across MySQL Server 5.5 through 8.0. The table contains these columns:
Name: The name of the function or operator.
Introduced: The version in which the function or operator was introduced.
Removed: The version in which the function or operator was removed.
5.5, 5.6, and so forth: Whether the function or operator is available in each MySQL Server series. If more information is available in the main reference manual, the indication is a link to the correct part of the manual.
Table 3.1 Operators/Functions Reference
| Name | Introduced | Deprecated | 5.5 | 5.6 | 5.7 | 8.0 |
|---|---|---|---|---|---|---|
ABS() |
Yes | Yes | Yes | Yes | ||
ACOS() |
Yes | Yes | Yes | Yes | ||
ADDDATE() |
Yes | Yes | Yes | Yes | ||
ADDTIME() |
Yes | Yes | Yes | Yes | ||
AES_DECRYPT() |
Yes | Yes | Yes | Yes | ||
AES_ENCRYPT() |
Yes | Yes | Yes | Yes | ||
AND, &&
|
Yes | Yes | Yes | Yes | ||
ANY_VALUE() |
5.7.5 | Yes | Yes | |||
Area() |
5.7.6 | Yes | Yes | Yes | ||
AsBinary(), AsWKB()
|
5.7.6 | Yes | Yes | Yes | ||
ASCII() |
Yes | Yes | Yes | Yes | ||
ASIN() |
Yes | Yes | Yes | Yes | ||
= |
Yes | Yes | Yes | Yes | ||
:= |
Yes | Yes | Yes | Yes | ||
AsText(), AsWKT()
|
5.7.6 | Yes | Yes | Yes | ||
ASYMMETRIC_DECRYPT() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
ASYMMETRIC_DERIVE() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
ASYMMETRIC_ENCRYPT() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
ASYMMETRIC_SIGN() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
ASYMMETRIC_VERIFY() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
ATAN() |
Yes | Yes | Yes | Yes | ||
ATAN2(), ATAN()
|
Yes | Yes | Yes | Yes | ||
AVG() |
Yes | Yes | Yes | Yes | ||
BENCHMARK() |
Yes | Yes | Yes | Yes | ||
BETWEEN ... AND ... |
Yes | Yes | Yes | Yes | ||
BIN() |
Yes | Yes | Yes | Yes | ||
BIN_TO_UUID() |
Yes | |||||
BINARY |
Yes | Yes | Yes | Yes | ||
BIT_AND() |
Yes | Yes | Yes | Yes | ||
BIT_COUNT() |
Yes | Yes | Yes | Yes | ||
BIT_LENGTH() |
Yes | Yes | Yes | Yes | ||
BIT_OR() |
Yes | Yes | Yes | Yes | ||
BIT_XOR() |
Yes | Yes | Yes | Yes | ||
& |
Yes | Yes | Yes | Yes | ||
~ |
Yes | Yes | Yes | Yes | ||
| |
Yes | Yes | Yes | Yes | ||
^ |
Yes | Yes | Yes | Yes | ||
Buffer() |
5.6.1 | 5.7.6 | Yes | Yes | ||
CAN_ACCESS_COLUMN() |
Yes | |||||
CAN_ACCESS_DATABASE() |
Yes | |||||
CAN_ACCESS_TABLE() |
Yes | |||||
CAN_ACCESS_VIEW() |
Yes | |||||
CASE |
Yes | Yes | Yes | Yes | ||
CAST() |
Yes | Yes | Yes | Yes | ||
CEIL() |
Yes | Yes | Yes | Yes | ||
CEILING() |
Yes | Yes | Yes | Yes | ||
Centroid() |
5.7.6 | Yes | Yes | Yes | ||
CHAR() |
Yes | Yes | Yes | Yes | ||
CHAR_LENGTH() |
Yes | Yes | Yes | Yes | ||
CHARACTER_LENGTH() |
Yes | Yes | Yes | Yes | ||
CHARSET() |
Yes | Yes | Yes | Yes | ||
COALESCE() |
Yes | Yes | Yes | Yes | ||
COERCIBILITY() |
Yes | Yes | Yes | Yes | ||
COLLATION() |
Yes | Yes | Yes | Yes | ||
COMPRESS() |
Yes | Yes | Yes | Yes | ||
CONCAT() |
Yes | Yes | Yes | Yes | ||
CONCAT_WS() |
Yes | Yes | Yes | Yes | ||
CONNECTION_ID() |
Yes | Yes | Yes | Yes | ||
Contains() |
5.7.6 | Yes | Yes | Yes | ||
CONV() |
Yes | Yes | Yes | Yes | ||
CONVERT() |
Yes | Yes | Yes | Yes | ||
CONVERT_TZ() |
Yes | Yes | Yes | Yes | ||
ConvexHull() |
5.7.5 | 5.7.6 | Yes | |||
COS() |
Yes | Yes | Yes | Yes | ||
COT() |
Yes | Yes | Yes | Yes | ||
COUNT() |
Yes | Yes | Yes | Yes | ||
COUNT(DISTINCT) |
Yes | Yes | Yes | Yes | ||
CRC32() |
Yes | Yes | Yes | Yes | ||
CREATE_ASYMMETRIC_PRIV_KEY() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
CREATE_ASYMMETRIC_PUB_KEY() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
CREATE_DH_PARAMETERS() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
CREATE_DIGEST() |
5.6.21, 5.7.9, 8.0.11 | Yes | Yes | Yes | ||
Crosses() |
5.7.6 | Yes | Yes | Yes | ||
CUME_DIST() |
8.0.2 | Yes | ||||
CURDATE() |
Yes | Yes | Yes | Yes | ||
CURRENT_DATE(), CURRENT_DATE
|
Yes | Yes | Yes | Yes | ||
CURRENT_ROLE() |
Yes | |||||
CURRENT_TIME(), CURRENT_TIME
|
Yes | Yes | Yes | Yes | ||
CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP
|
Yes | Yes | Yes | Yes | ||
CURRENT_USER(), CURRENT_USER
|
Yes | Yes | Yes | Yes | ||
CURTIME() |
Yes | Yes | Yes | Yes | ||
DATABASE() |
Yes | Yes | Yes | Yes | ||
DATE() |
Yes | Yes | Yes | Yes | ||
DATE_ADD() |
Yes | Yes | Yes | Yes | ||
DATE_FORMAT() |
Yes | Yes | Yes | Yes | ||
DATE_SUB() |
Yes | Yes | Yes | Yes | ||
DATEDIFF() |
Yes | Yes | Yes | Yes | ||
DAY() |
Yes | Yes | Yes | Yes | ||
DAYNAME() |
Yes | Yes | Yes | Yes | ||
DAYOFMONTH() |
Yes | Yes | Yes | Yes | ||
DAYOFWEEK() |
Yes | Yes | Yes | Yes | ||
DAYOFYEAR() |
Yes | Yes | Yes | Yes | ||
DECODE() |
5.7.2 | Yes | Yes | Yes | Yes | |
DEFAULT() |
Yes | Yes | Yes | Yes | ||
DEGREES() |
Yes | Yes | Yes | Yes | ||
DENSE_RANK() |
8.0.2 | Yes | ||||
DES_DECRYPT() |
5.7.6 | Yes | Yes | Yes | Yes | |
DES_ENCRYPT() |
5.7.6 | Yes | Yes | Yes | Yes | |
Dimension() |
5.7.6 | Yes | Yes | Yes | ||
Disjoint() |
5.7.6 | Yes | Yes | Yes | ||
Distance() |
5.7.5 | 5.7.6 | Yes | |||
DIV |
Yes | Yes | Yes | Yes | ||
/ |
Yes | Yes | Yes | Yes | ||
ELT() |
Yes | Yes | Yes | Yes | ||
ENCODE() |
5.7.2 | Yes | Yes | Yes | Yes | |
ENCRYPT() |
5.7.6 | Yes | Yes | Yes | Yes | |
EndPoint() |
5.7.6 | Yes | Yes | Yes | ||
Envelope() |
5.7.6 | Yes | Yes | Yes | ||
= |
Yes | Yes | Yes | Yes | ||
<=> |
Yes | Yes | Yes | Yes | ||
Equals() |
5.7.6 | Yes | Yes | Yes | ||
EXP() |
Yes | Yes | Yes | Yes | ||
EXPORT_SET() |
Yes | Yes | Yes | Yes | ||
ExteriorRing() |
5.7.6 | Yes | Yes | Yes | ||
EXTRACT() |
Yes | Yes | Yes | Yes | ||
ExtractValue() |
Yes | Yes | Yes | Yes | ||
FIELD() |
Yes | Yes | Yes | Yes | ||
FIND_IN_SET() |
Yes | Yes | Yes | Yes | ||
FIRST_VALUE() |
8.0.2 | Yes | ||||
FLOOR() |
Yes | Yes | Yes | Yes | ||
FORMAT() |
Yes | Yes | Yes | Yes | ||
FORMAT_BYTES() |
8.0.16 | Yes | ||||
FORMAT_PICO_TIME() |
8.0.16 | Yes | ||||
FOUND_ROWS() |
Yes | Yes | Yes | Yes | ||
FROM_BASE64() |
5.6.1 | Yes | Yes | Yes | ||
FROM_DAYS() |
Yes | Yes | Yes | Yes | ||
FROM_UNIXTIME() |
Yes | Yes | Yes | Yes | ||
GeomCollection() |
8.0.11 | Yes | ||||
GeomCollFromText(), GeometryCollectionFromText()
|
5.7.6 | Yes | Yes | Yes | ||
GeomCollFromWKB(), GeometryCollectionFromWKB()
|
5.7.6 | Yes | Yes | Yes | ||
GeometryCollection() |
Yes | Yes | Yes | Yes | ||
GeometryN() |
5.7.6 | Yes | Yes | Yes | ||
GeometryType() |
5.7.6 | Yes | Yes | Yes | ||
GeomFromText(), GeometryFromText()
|
5.7.6 | Yes | Yes | Yes | ||
GeomFromWKB(), GeometryFromWKB()
|
5.7.6 | Yes | Yes | Yes | ||
GET_DD_COLUMN_PRIVILEGES() |
Yes | |||||
GET_DD_CREATE_OPTIONS() |
Yes | |||||
GET_DD_INDEX_SUB_PART_LENGTH() |
Yes | |||||
GET_FORMAT() |
Yes | Yes | Yes | Yes | ||
GET_LOCK() |
Yes | Yes | Yes | Yes | ||
GLength() |
5.7.6 | Yes | Yes | Yes | ||
> |
Yes | Yes | Yes | Yes | ||
>= |
Yes | Yes | Yes | Yes | ||
GREATEST() |
Yes | Yes | Yes | Yes | ||
GROUP_CONCAT() |
Yes | Yes | Yes | Yes | ||
GROUPING() |
8.0.1 | Yes | ||||
GTID_SUBSET() |
5.6.5 | Yes | Yes | Yes | ||
GTID_SUBTRACT() |
5.6.5 | Yes | Yes | Yes | ||
HEX() |
Yes | Yes | Yes | Yes | ||
HOUR() |
Yes | Yes | Yes | Yes | ||
ICU_VERSION() |
8.0.4 | Yes | ||||
IF() |
Yes | Yes | Yes | Yes | ||
IFNULL() |
Yes | Yes | Yes | Yes | ||
IN() |
Yes | Yes | Yes | Yes | ||
INET_ATON() |
Yes | Yes | Yes | Yes | ||
INET_NTOA() |
Yes | Yes | Yes | Yes | ||
INET6_ATON() |
5.6.3 | Yes | Yes | Yes | ||
INET6_NTOA() |
5.6.3 | Yes | Yes | Yes | ||
INSERT() |
Yes | Yes | Yes | Yes | ||
INSTR() |
Yes | Yes | Yes | Yes | ||
InteriorRingN() |
5.7.6 | Yes | Yes | Yes | ||
INTERNAL_AUTO_INCREMENT() |
Yes | |||||
INTERNAL_AVG_ROW_LENGTH() |
Yes | |||||
INTERNAL_CHECK_TIME() |
Yes | |||||
INTERNAL_CHECKSUM() |
Yes | |||||
INTERNAL_DATA_FREE() |
Yes | |||||
INTERNAL_DATA_LENGTH() |
Yes | |||||
INTERNAL_DD_CHAR_LENGTH() |
Yes | |||||
INTERNAL_GET_COMMENT_OR_ERROR() |
Yes | |||||
INTERNAL_GET_VIEW_WARNING_OR_ERROR() |
Yes | |||||
INTERNAL_INDEX_COLUMN_CARDINALITY() |
Yes | |||||
INTERNAL_INDEX_LENGTH() |
Yes | |||||
INTERNAL_KEYS_DISABLED() |
Yes | |||||
INTERNAL_MAX_DATA_LENGTH() |
Yes | |||||
INTERNAL_TABLE_ROWS() |
Yes | |||||
INTERNAL_UPDATE_TIME() |
Yes | |||||
Intersects() |
5.7.6 | Yes | Yes | Yes | ||
INTERVAL() |
Yes | Yes | Yes | Yes | ||
IS |
Yes | Yes | Yes | Yes | ||
IS_FREE_LOCK() |
Yes | Yes | Yes | Yes | ||
IS_IPV4() |
5.6.3 | Yes | Yes | Yes | ||
IS_IPV4_COMPAT() |
5.6.3 | Yes | Yes | Yes | ||
IS_IPV4_MAPPED() |
5.6.3 | Yes | Yes | Yes | ||
IS_IPV6() |
5.6.3 | Yes | Yes | Yes | ||
IS NOT |
Yes | Yes | Yes | Yes | ||
IS NOT NULL |
Yes | Yes | Yes | Yes | ||
IS NULL |
Yes | Yes | Yes | Yes | ||
IS_USED_LOCK() |
Yes | Yes | Yes | Yes | ||
IS_UUID() |
Yes | |||||
IsClosed() |
5.7.6 | Yes | Yes | Yes | ||
IsEmpty() |
5.7.6 | Yes | Yes | Yes | ||
ISNULL() |
Yes | Yes | Yes | Yes | ||
IsSimple() |
5.7.6 | Yes | Yes | Yes | ||
JSON_APPEND() |
5.7.8 | 5.7.9 | Yes | |||
JSON_ARRAY() |
5.7.8 | Yes | Yes | |||
JSON_ARRAY_APPEND() |
5.7.9 | Yes | Yes | |||
JSON_ARRAY_INSERT() |
5.7.8 | Yes | Yes | |||
JSON_ARRAYAGG() |
5.7.22, 8.0.1 | Yes | Yes | |||
-> |
5.7.9 | Yes | Yes | |||
JSON_CONTAINS() |
5.7.8 | Yes | Yes | |||
JSON_CONTAINS_PATH() |
5.7.8 | Yes | Yes | |||
JSON_DEPTH() |
5.7.8 | Yes | Yes | |||
JSON_EXTRACT() |
5.7.8 | Yes | Yes | |||
->> |
5.7.13, 8.0.0 | Yes | Yes | |||
JSON_INSERT() |
5.7.8 | Yes | Yes | |||
JSON_KEYS() |
5.7.8 | Yes | Yes | |||
JSON_LENGTH() |
5.7.8 | Yes | Yes | |||
JSON_MERGE() |
5.7.8 | 5.7.22, 8.0.3 | Yes | Yes | ||
JSON_MERGE_PATCH() |
5.7.22, 8.0.3 | Yes | Yes | |||
JSON_MERGE_PRESERVE() |
5.7.22, 8.0.3 | Yes | Yes | |||
JSON_OBJECT() |
5.7.8 | Yes | Yes | |||
JSON_OBJECTAGG() |
5.7.22, 8.0.1 | Yes | Yes | |||
JSON_PRETTY() |
5.7.22, 8.0.1 | Yes | Yes | |||
JSON_QUOTE() |
5.7.8 | Yes | Yes | |||
JSON_REMOVE() |
5.7.8 | Yes | Yes | |||
JSON_REPLACE() |
5.7.8 | Yes | Yes | |||
JSON_SCHEMA_VALID() |
8.0.17 | Yes | ||||
JSON_SCHEMA_VALIDATION_REPORT() |
8.0.17 | Yes | ||||
JSON_SEARCH() |
5.7.8 | Yes | Yes | |||
JSON_SET() |
5.7.8 | Yes | Yes | |||
JSON_STORAGE_FREE() |
8.0.2 | Yes | ||||
JSON_STORAGE_SIZE() |
5.7.22, 8.0.2 | Yes | Yes | |||
JSON_TABLE() |
8.0.4 | Yes | ||||
JSON_TYPE() |
5.7.8 | Yes | Yes | |||
JSON_UNQUOTE() |
5.7.8 | Yes | Yes | |||
JSON_VALID() |
5.7.8 | Yes | Yes | |||
LAG() |
8.0.2 | Yes | ||||
LAST_DAY |
Yes | Yes | Yes | Yes | ||
LAST_INSERT_ID() |
Yes | Yes | Yes | Yes | ||
LAST_VALUE() |
8.0.2 | Yes | ||||
LCASE() |
Yes | Yes | Yes | Yes | ||
LEAD() |
8.0.2 | Yes | ||||
LEAST() |
Yes | Yes | Yes | Yes | ||
LEFT() |
Yes | Yes | Yes | Yes | ||
<< |
Yes | Yes | Yes | Yes | ||
LENGTH() |
Yes | Yes | Yes | Yes | ||
< |
Yes | Yes | Yes | Yes | ||
<= |
Yes | Yes | Yes | Yes | ||
LIKE |
Yes | Yes | Yes | Yes | ||
LineFromText(), LineStringFromText()
|
5.7.6 | Yes | Yes | Yes | ||
LineFromWKB(), LineStringFromWKB()
|
5.7.6 | Yes | Yes | Yes | ||
LineString() |
Yes | Yes | Yes | Yes | ||
LN() |
Yes | Yes | Yes | Yes | ||
LOAD_FILE() |
Yes | Yes | Yes | Yes | ||
LOCALTIME(), LOCALTIME
|
Yes | Yes | Yes | Yes | ||
LOCALTIMESTAMP, LOCALTIMESTAMP()
|
Yes | Yes | Yes | Yes | ||
LOCATE() |
Yes | Yes | Yes | Yes | ||
LOG() |
Yes | Yes | Yes | Yes | ||
LOG10() |
Yes | Yes | Yes | Yes | ||
LOG2() |
Yes | Yes | Yes | Yes | ||
LOWER() |
Yes | Yes | Yes | Yes | ||
LPAD() |
Yes | Yes | Yes | Yes | ||
LTRIM() |
Yes | Yes | Yes | Yes | ||
MAKE_SET() |
Yes | Yes | Yes | Yes | ||
MAKEDATE() |
Yes | Yes | Yes | Yes | ||
MAKETIME() |
Yes | Yes | Yes | Yes | ||
MASTER_POS_WAIT() |
Yes | Yes | Yes | Yes | ||
MATCH |
Yes | Yes | Yes | Yes | ||
MAX() |
Yes | Yes | Yes | Yes | ||
MBRContains() |
Yes | Yes | Yes | Yes | ||
MBRCoveredBy() |
5.7.6 | Yes | Yes | |||
MBRCovers() |
5.7.6 | Yes | Yes | |||
MBRDisjoint() |
Yes | Yes | Yes | Yes | ||
MBREqual() |
5.7.6 | Yes | Yes | Yes | ||
MBREquals() |
5.7.6 | Yes | Yes | |||
MBRIntersects() |
Yes | Yes | Yes | Yes | ||
MBROverlaps() |
Yes | Yes | Yes | Yes | ||
MBRTouches() |
Yes | Yes | Yes | Yes | ||
MBRWithin() |
Yes | Yes | Yes | Yes | ||
MD5() |
Yes | Yes | Yes | Yes | ||
MICROSECOND() |
Yes | Yes | Yes | Yes | ||
MID() |
Yes | Yes | Yes | Yes | ||
MIN() |
Yes | Yes | Yes | Yes | ||
- |
Yes | Yes | Yes | Yes | ||
MINUTE() |
Yes | Yes | Yes | Yes | ||
MLineFromText(), MultiLineStringFromText()
|
5.7.6 | Yes | Yes | Yes | ||
MLineFromWKB(), MultiLineStringFromWKB()
|
5.7.6 | Yes | Yes | Yes | ||
MOD() |
Yes | Yes | Yes | Yes | ||
%, MOD
|
Yes | Yes | Yes | Yes | ||
MONTH() |
Yes | Yes | Yes | Yes | ||
MONTHNAME() |
Yes | Yes | Yes | Yes | ||
MPointFromText(), MultiPointFromText()
|
5.7.6 | Yes | Yes | Yes | ||
MPointFromWKB(), MultiPointFromWKB()
|
5.7.6 | Yes | Yes | Yes | ||
MPolyFromText(), MultiPolygonFromText()
|
5.7.6 | Yes | Yes | Yes | ||
MPolyFromWKB(), MultiPolygonFromWKB()
|
5.7.6 | Yes | Yes | Yes | ||
MultiLineString() |
Yes | Yes | Yes | Yes | ||
MultiPoint() |
Yes | Yes | Yes | Yes | ||
MultiPolygon() |
Yes | Yes | Yes | Yes | ||
NAME_CONST() |
Yes | Yes | Yes | Yes | ||
NOT, !
|
Yes | Yes | Yes | Yes | ||
NOT BETWEEN ... AND ... |
Yes | Yes | Yes | Yes | ||
!=, <>
|
Yes | Yes | Yes | Yes | ||
NOT IN() |
Yes | Yes | Yes | Yes | ||
NOT LIKE |
Yes | Yes | Yes | Yes | ||
NOT REGEXP |
Yes | Yes | Yes | Yes | ||
NOW() |
Yes | Yes | Yes | Yes | ||
NTH_VALUE() |
8.0.2 | Yes | ||||
NTILE() |
8.0.2 | Yes | ||||
NULLIF() |
Yes | Yes | Yes | Yes | ||
NumGeometries() |
5.7.6 | Yes | Yes | Yes | ||
NumInteriorRings() |
5.7.6 | Yes | Yes | Yes | ||
NumPoints() |
5.7.6 | Yes | Yes | Yes | ||
OCT() |
Yes | Yes | Yes | Yes | ||
OCTET_LENGTH() |
Yes | Yes | Yes | Yes | ||
OLD_PASSWORD() |
5.6.5 | Yes | Yes | Yes | ||
OR, ||
|
Yes | Yes | Yes | Yes | ||
ORD() |
Yes | Yes | Yes | Yes | ||
Overlaps() |
5.7.6 | Yes | Yes | Yes | ||
PASSWORD() |
5.7.6 | Yes | Yes | Yes | Yes | |
PERCENT_RANK() |
8.0.2 | Yes | ||||
PERIOD_ADD() |
Yes | Yes | Yes | Yes | ||
PERIOD_DIFF() |
Yes | Yes | Yes | Yes | ||
PI() |
Yes | Yes | Yes | Yes | ||
+ |
Yes | Yes | Yes | Yes | ||
Point() |
Yes | Yes | Yes | Yes | ||
PointFromText() |
5.7.6 | Yes | Yes | Yes | ||
PointFromWKB() |
5.7.6 | Yes | Yes | Yes | ||
PointN() |
5.7.6 | Yes | Yes | Yes | ||
PolyFromText(), PolygonFromText()
|
5.7.6 | Yes | Yes | Yes | ||
PolyFromWKB(), PolygonFromWKB()
|
5.7.6 | Yes | Yes | Yes | ||
Polygon() |
Yes | Yes | Yes | Yes | ||
POSITION() |
Yes | Yes | Yes | Yes | ||
POW() |
Yes | Yes | Yes | Yes | ||
POWER() |
Yes | Yes | Yes | Yes | ||
PROCEDURE ANALYSE() |
5.7.18 | Yes | Yes | Yes | ||
PS_CURRENT_THREAD_ID() |
8.0.16 | Yes | ||||
PS_THREAD_ID() |
8.0.16 | Yes | ||||
QUARTER() |
Yes | Yes | Yes | Yes | ||
QUOTE() |
Yes | Yes | Yes | Yes | ||
RADIANS() |
Yes | Yes | Yes | Yes | ||
RAND() |
Yes | Yes | Yes | Yes | ||
RANDOM_BYTES() |
5.6.17, 5.7.4 | Yes | Yes | Yes | ||
RANK() |
8.0.2 | Yes | ||||
REGEXP |
Yes | Yes | Yes | Yes | ||
REGEXP_INSTR() |
8.0.4 | Yes | ||||
REGEXP_LIKE() |
8.0.4 | Yes | ||||
REGEXP_REPLACE() |
8.0.4 | Yes | ||||
REGEXP_SUBSTR() |
8.0.4 | Yes | ||||
RELEASE_ALL_LOCKS() |
5.7.5 | Yes | Yes | |||
RELEASE_LOCK() |
Yes | Yes | Yes | Yes | ||
REPEAT() |
Yes | Yes | Yes | Yes | ||
REPLACE() |
Yes | Yes | Yes | Yes | ||
REVERSE() |
Yes | Yes | Yes | Yes | ||
RIGHT() |
Yes | Yes | Yes | Yes | ||
>> |
Yes | Yes | Yes | Yes | ||
RLIKE |
Yes | Yes | Yes | Yes | ||
ROLES_GRAPHML() |
Yes | |||||
ROUND() |
Yes | Yes | Yes | Yes | ||
ROW_COUNT() |
Yes | Yes | Yes | Yes | ||
ROW_NUMBER() |
8.0.2 | Yes | ||||
RPAD() |
Yes | Yes | Yes | Yes | ||
RTRIM() |
Yes | Yes | Yes | Yes | ||
SCHEMA() |
Yes | Yes | Yes | Yes | ||
SEC_TO_TIME() |
Yes | Yes | Yes | Yes | ||
SECOND() |
Yes | Yes | Yes | Yes | ||
SESSION_USER() |
Yes | Yes | Yes | Yes | ||
SHA1(), SHA()
|
Yes | Yes | Yes | Yes | ||
SHA2() |
5.5.5 | Yes | Yes | Yes | Yes | |
SIGN() |
Yes | Yes | Yes | Yes | ||
SIN() |
Yes | Yes | Yes | Yes | ||
SLEEP() |
Yes | Yes | Yes | Yes | ||
SOUNDEX() |
Yes | Yes | Yes | Yes | ||
SOUNDS LIKE |
Yes | Yes | Yes | Yes | ||
SPACE() |
Yes | Yes | Yes | Yes | ||
SQL_THREAD_WAIT_AFTER_GTIDS() |
5.6.5 | 5.6.9 | Yes | |||
SQRT() |
Yes | Yes | Yes | Yes | ||
SRID() |
5.7.6 | Yes | Yes | Yes | ||
ST_Area() |
5.6.1 | Yes | Yes | Yes | ||
ST_AsBinary(), ST_AsWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_AsGeoJSON() |
5.7.5 | Yes | Yes | |||
ST_AsText(), ST_AsWKT()
|
5.6.1 | Yes | Yes | Yes | ||
ST_Buffer() |
5.6.1 | Yes | Yes | Yes | ||
ST_Buffer_Strategy() |
5.7.7 | Yes | Yes | |||
ST_Centroid() |
5.6.1 | Yes | Yes | Yes | ||
ST_Contains() |
5.6.1 | Yes | Yes | Yes | ||
ST_ConvexHull() |
5.7.5 | Yes | Yes | |||
ST_Crosses() |
5.6.1 | Yes | Yes | Yes | ||
ST_Difference() |
5.6.1 | Yes | Yes | Yes | ||
ST_Dimension() |
5.6.1 | Yes | Yes | Yes | ||
ST_Disjoint() |
5.6.1 | Yes | Yes | Yes | ||
ST_Distance() |
5.6.1 | Yes | Yes | Yes | ||
ST_Distance_Sphere() |
5.7.6 | Yes | Yes | |||
ST_EndPoint() |
5.6.1 | Yes | Yes | Yes | ||
ST_Envelope() |
5.6.1 | Yes | Yes | Yes | ||
ST_Equals() |
5.6.1 | Yes | Yes | Yes | ||
ST_ExteriorRing() |
5.6.1 | Yes | Yes | Yes | ||
ST_GeoHash() |
5.7.5 | Yes | Yes | |||
ST_GeomCollFromText(), ST_GeometryCollectionFromText(), ST_GeomCollFromTxt()
|
5.6.1 | Yes | Yes | Yes | ||
ST_GeomCollFromWKB(), ST_GeometryCollectionFromWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_GeometryN() |
5.6.1 | Yes | Yes | Yes | ||
ST_GeometryType() |
5.6.1 | Yes | Yes | Yes | ||
ST_GeomFromGeoJSON() |
5.7.5 | Yes | Yes | |||
ST_GeomFromText(), ST_GeometryFromText()
|
5.6.1 | Yes | Yes | Yes | ||
ST_GeomFromWKB(), ST_GeometryFromWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_InteriorRingN() |
5.6.1 | Yes | Yes | Yes | ||
ST_Intersection() |
5.6.1 | Yes | Yes | Yes | ||
ST_Intersects() |
5.6.1 | Yes | Yes | Yes | ||
ST_IsClosed() |
5.6.1 | Yes | Yes | Yes | ||
ST_IsEmpty() |
5.6.1 | Yes | Yes | Yes | ||
ST_IsSimple() |
5.6.1 | Yes | Yes | Yes | ||
ST_IsValid() |
5.7.6 | Yes | Yes | |||
ST_LatFromGeoHash() |
5.7.5 | Yes | Yes | |||
ST_Latitude() |
8.0.12 | Yes | ||||
ST_Length() |
5.7.6 | Yes | Yes | |||
ST_LineFromText(), ST_LineStringFromText()
|
5.6.1 | Yes | Yes | Yes | ||
ST_LineFromWKB(), ST_LineStringFromWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_LongFromGeoHash() |
5.7.5 | Yes | Yes | |||
ST_Longitude() |
8.0.12 | Yes | ||||
ST_MakeEnvelope() |
5.7.6 | Yes | Yes | |||
ST_MLineFromText(), ST_MultiLineStringFromText()
|
5.7.6 | Yes | Yes | |||
ST_MLineFromWKB(), ST_MultiLineStringFromWKB()
|
5.7.6 | Yes | Yes | |||
ST_MPointFromText(), ST_MultiPointFromText()
|
5.7.6 | Yes | Yes | |||
ST_MPointFromWKB(), ST_MultiPointFromWKB()
|
5.7.6 | Yes | Yes | |||
ST_MPolyFromText(), ST_MultiPolygonFromText()
|
5.7.6 | Yes | Yes | |||
ST_MPolyFromWKB(), ST_MultiPolygonFromWKB()
|
5.7.6 | Yes | Yes | |||
ST_NumGeometries() |
5.6.1 | Yes | Yes | Yes | ||
ST_NumInteriorRing(), ST_NumInteriorRings()
|
5.6.1 | Yes | Yes | Yes | ||
ST_NumPoints() |
5.6.1 | Yes | Yes | Yes | ||
ST_Overlaps() |
5.6.1 | Yes | Yes | Yes | ||
ST_PointFromGeoHash() |
5.7.5 | Yes | Yes | |||
ST_PointFromText() |
5.6.1 | Yes | Yes | Yes | ||
ST_PointFromWKB() |
5.6.1 | Yes | Yes | Yes | ||
ST_PointN() |
5.6.1 | Yes | Yes | Yes | ||
ST_PolyFromText(), ST_PolygonFromText()
|
5.6.1 | Yes | Yes | Yes | ||
ST_PolyFromWKB(), ST_PolygonFromWKB()
|
5.6.1 | Yes | Yes | Yes | ||
ST_Simplify() |
5.7.6 | Yes | Yes | |||
ST_SRID() |
5.6.1 | Yes | Yes | Yes | ||
ST_StartPoint() |
5.6.1 | Yes | Yes | Yes | ||
ST_SwapXY() |
8.0.1 | Yes | ||||
ST_SymDifference() |
5.6.1 | Yes | Yes | Yes | ||
ST_Touches() |
5.6.1 | Yes | Yes | Yes | ||
ST_Transform() |
8.0.13 | Yes | ||||
ST_Union() |
5.6.1 | Yes | Yes | Yes | ||
ST_Validate() |
5.7.6 | Yes | Yes | |||
ST_Within() |
5.6.1 | Yes | Yes | Yes | ||
ST_X() |
5.6.1 | Yes | Yes | Yes | ||
ST_Y() |
5.6.1 | Yes | Yes | Yes | ||
StartPoint() |
5.7.6 | Yes | Yes | Yes | ||
STATEMENT_DIGEST() |
8.0.4 | Yes | ||||
STATEMENT_DIGEST_TEXT() |
8.0.4 | Yes | ||||
STD() |
Yes | Yes | Yes | Yes | ||
STDDEV() |
Yes | Yes | Yes | Yes | ||
STDDEV_POP() |
Yes | Yes | Yes | Yes | ||
STDDEV_SAMP() |
Yes | Yes | Yes | Yes | ||
STR_TO_DATE() |
Yes | Yes | Yes | Yes | ||
STRCMP() |
Yes | Yes | Yes | Yes | ||
SUBDATE() |
Yes | Yes | Yes | Yes | ||
SUBSTR() |
Yes | Yes | Yes | Yes | ||
SUBSTRING() |
Yes | Yes | Yes | Yes | ||
SUBSTRING_INDEX() |
Yes | Yes | Yes | Yes | ||
SUBTIME() |
Yes | Yes | Yes | Yes | ||
SUM() |
Yes | Yes | Yes | Yes | ||
SYSDATE() |
Yes | Yes | Yes | Yes | ||
SYSTEM_USER() |
Yes | Yes | Yes | Yes | ||
TAN() |
Yes | Yes | Yes | Yes | ||
TIME() |
Yes | Yes | Yes | Yes | ||
TIME_FORMAT() |
Yes | Yes | Yes | Yes | ||
TIME_TO_SEC() |
Yes | Yes | Yes | Yes | ||
TIMEDIFF() |
Yes | Yes | Yes | Yes | ||
* |
Yes | Yes | Yes | Yes | ||
TIMESTAMP() |
Yes | Yes | Yes | Yes | ||
TIMESTAMPADD() |
Yes | Yes | Yes | Yes | ||
TIMESTAMPDIFF() |
Yes | Yes | Yes | Yes | ||
TO_BASE64() |
5.6.1 | Yes | Yes | Yes | ||
TO_DAYS() |
Yes | Yes | Yes | Yes | ||
TO_SECONDS() |
Yes | Yes | Yes | Yes | ||
Touches() |
5.7.6 | Yes | Yes | Yes | ||
TRIM() |
Yes | Yes | Yes | Yes | ||
TRUNCATE() |
Yes | Yes | Yes | Yes | ||
UCASE() |
Yes | Yes | Yes | Yes | ||
- |
Yes | Yes | Yes | Yes | ||
UNCOMPRESS() |
Yes | Yes | Yes | Yes | ||
UNCOMPRESSED_LENGTH() |
Yes | Yes | Yes | Yes | ||
UNHEX() |
Yes | Yes | Yes | Yes | ||
UNIX_TIMESTAMP() |
Yes | Yes | Yes | Yes | ||
UpdateXML() |
Yes | Yes | Yes | Yes | ||
UPPER() |
Yes | Yes | Yes | Yes | ||
USER() |
Yes | Yes | Yes | Yes | ||
UTC_DATE() |
Yes | Yes | Yes | Yes | ||
UTC_TIME() |
Yes | Yes | Yes | Yes | ||
UTC_TIMESTAMP() |
Yes | Yes | Yes | Yes | ||
UUID() |
Yes | Yes | Yes | Yes | ||
UUID_SHORT() |
Yes | Yes | Yes | Yes | ||
UUID_TO_BIN() |
Yes | |||||
VALIDATE_PASSWORD_STRENGTH() |
5.6.6 | Yes | Yes | Yes | ||
VALUES() |
Yes | Yes | Yes | Yes | ||
VAR_POP() |
Yes | Yes | Yes | Yes | ||
VAR_SAMP() |
Yes | Yes | Yes | Yes | ||
VARIANCE() |
Yes | Yes | Yes | Yes | ||
VERSION() |
Yes | Yes | Yes | Yes | ||
WAIT_FOR_EXECUTED_GTID_SET() |
5.7.5 | Yes | Yes | |||
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() |
5.6.9 | Yes | Yes | Yes | ||
WEEK() |
Yes | Yes | Yes | Yes | ||
WEEKDAY() |
Yes | Yes | Yes | Yes | ||
WEEKOFYEAR() |
Yes | Yes | Yes | Yes | ||
WEIGHT_STRING() |
Yes | Yes | Yes | |||
Within() |
5.7.6 | Yes | Yes | Yes | ||
X() |
5.7.6 | Yes | Yes | Yes | ||
XOR |
Yes | Yes | Yes | Yes | ||
Y() |
5.7.6 | Yes | Yes | Yes | ||
YEAR() |
Yes | Yes | Yes | Yes | ||
YEARWEEK() |
Yes | Yes | Yes | Yes |