PDF (US Ltr)
- 2.5Mb
PDF (A4)
- 2.5Mb
The following table shows all built-in functions and operators available in MySQL Server 5.7, 8.0, 8.1, 8.2, and 8.3. The table contains these columns:
Name: The item name.
Introduced: The version or versions in which the item was introduced. This column appears only if it applies to some item.
Deprecated: The version or versions in which the item was deprecated. This column appears only if it applies to some item.
Removed: The version or versions in which the item was removed. This column appears only if it applies to some item.
-
5.7, 8.0, 8.1, 8.2, 8.3: Whether the item is available in the corresponding MySQL Server release series. The indicator links to the item description in the main reference manual if more information is available.
An item has a row in the table if it ever existed in any series shown in the table. The value displayed for a given series indicates item availability in that series:
Yes: The item is available in all production-ready General Availability (GA) versions. For a series that has not reached GA status, Yes indicates that the item is available in the most recently released pre-GA version.
Some: The item is available in some GA versions. This is the case if the item was introduced after the first GA version, or removed from some GA version.
Blank: The item is not available in any GA version. Either it does not exist in the series, or existed in pre-GA versions but was removed before the series reached GA status.
Table 2.1 Built-In Function and Operator Reference
| Name | Introduced | Deprecated | Removed | 5.7 | 8.0 | 8.1 | 8.2 | 8.3 |
|---|---|---|---|---|---|---|---|---|
& |
Yes | Yes | Yes | Yes | Yes | |||
> |
Yes | Yes | Yes | Yes | Yes | |||
>> |
Yes | Yes | Yes | Yes | Yes | |||
>= |
Yes | Yes | Yes | Yes | Yes | |||
< |
Yes | Yes | Yes | Yes | Yes | |||
<>, !=
|
Yes | Yes | Yes | Yes | Yes | |||
<< |
Yes | Yes | Yes | Yes | Yes | |||
<= |
Yes | Yes | Yes | Yes | Yes | |||
<=> |
Yes | Yes | Yes | Yes | Yes | |||
%, MOD
|
Yes | Yes | Yes | Yes | Yes | |||
* |
Yes | Yes | Yes | Yes | Yes | |||
+ |
Yes | Yes | Yes | Yes | Yes | |||
- |
Yes | Yes | Yes | Yes | Yes | |||
- |
Yes | Yes | Yes | Yes | Yes | |||
-> |
5.7.9 | Yes | Yes | Yes | Yes | Yes | ||
->> |
5.7.13 | Some | Yes | Yes | Yes | Yes | ||
/ |
Yes | Yes | Yes | Yes | Yes | |||
:= |
Yes | Yes | Yes | Yes | Yes | |||
= |
Yes | Yes | Yes | Yes | Yes | |||
= |
Yes | Yes | Yes | Yes | Yes | |||
^ |
Yes | Yes | Yes | Yes | Yes | |||
ABS() |
Yes | Yes | Yes | Yes | Yes | |||
ACOS() |
Yes | Yes | Yes | Yes | Yes | |||
ADDDATE() |
Yes | Yes | Yes | Yes | Yes | |||
ADDTIME() |
Yes | Yes | Yes | Yes | Yes | |||
AES_DECRYPT() |
Yes | Yes | Yes | Yes | Yes | |||
AES_ENCRYPT() |
Yes | Yes | Yes | Yes | Yes | |||
AND, &&
|
Yes | Yes | Yes | Yes | Yes | |||
ANY_VALUE() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
Area() |
5.7.6 | Yes | ||||||
AsBinary(), AsWKB()
|
5.7.6 | Yes | ||||||
ASCII() |
Yes | Yes | Yes | Yes | Yes | |||
ASIN() |
Yes | Yes | Yes | Yes | Yes | |||
AsText(), AsWKT()
|
5.7.6 | Yes | ||||||
asynchronous_connection_failover_add_managed() |
8.0.23 | Some | Yes | Yes | Yes | |||
asynchronous_connection_failover_add_source() |
8.0.22 | Some | Yes | Yes | Yes | |||
asynchronous_connection_failover_delete_managed() |
8.0.23 | Some | Yes | Yes | Yes | |||
asynchronous_connection_failover_delete_source() |
8.0.22 | Some | Yes | Yes | Yes | |||
asynchronous_connection_failover_reset() |
8.0.27 | Some | Yes | Yes | Yes | |||
ATAN() |
Yes | Yes | Yes | Yes | Yes | |||
ATAN2(), ATAN()
|
Yes | Yes | Yes | Yes | Yes | |||
AVG() |
Yes | Yes | Yes | Yes | Yes | |||
BENCHMARK() |
Yes | Yes | Yes | Yes | Yes | |||
BETWEEN ... AND ... |
Yes | Yes | Yes | Yes | Yes | |||
BIN() |
Yes | Yes | Yes | Yes | Yes | |||
BIN_TO_UUID() |
Yes | Yes | Yes | Yes | ||||
BINARY |
8.0.27 | Yes | Yes | Yes | Yes | Yes | ||
BIT_AND() |
Yes | Yes | Yes | Yes | Yes | |||
BIT_COUNT() |
Yes | Yes | Yes | Yes | Yes | |||
BIT_LENGTH() |
Yes | Yes | Yes | Yes | Yes | |||
BIT_OR() |
Yes | Yes | Yes | Yes | Yes | |||
BIT_XOR() |
Yes | Yes | Yes | Yes | Yes | |||
Buffer() |
5.7.6 | Yes | ||||||
CAN_ACCESS_COLUMN() |
Yes | Yes | Yes | Yes | ||||
CAN_ACCESS_DATABASE() |
Yes | Yes | Yes | Yes | ||||
CAN_ACCESS_TABLE() |
Yes | Yes | Yes | Yes | ||||
CAN_ACCESS_USER() |
8.0.22 | Some | Yes | Yes | Yes | |||
CAN_ACCESS_VIEW() |
Yes | Yes | Yes | Yes | ||||
CASE |
Yes | Yes | Yes | Yes | Yes | |||
CAST() |
Yes | Yes | Yes | Yes | Yes | |||
CEIL() |
Yes | Yes | Yes | Yes | Yes | |||
CEILING() |
Yes | Yes | Yes | Yes | Yes | |||
Centroid() |
5.7.6 | Yes | ||||||
CHAR() |
Yes | Yes | Yes | Yes | Yes | |||
CHAR_LENGTH() |
Yes | Yes | Yes | Yes | Yes | |||
CHARACTER_LENGTH() |
Yes | Yes | Yes | Yes | Yes | |||
CHARSET() |
Yes | Yes | Yes | Yes | Yes | |||
COALESCE() |
Yes | Yes | Yes | Yes | Yes | |||
COERCIBILITY() |
Yes | Yes | Yes | Yes | Yes | |||
COLLATION() |
Yes | Yes | Yes | Yes | Yes | |||
COMPRESS() |
Yes | Yes | Yes | Yes | Yes | |||
CONCAT() |
Yes | Yes | Yes | Yes | Yes | |||
CONCAT_WS() |
Yes | Yes | Yes | Yes | Yes | |||
CONNECTION_ID() |
Yes | Yes | Yes | Yes | Yes | |||
Contains() |
5.7.6 | Yes | ||||||
CONV() |
Yes | Yes | Yes | Yes | Yes | |||
CONVERT() |
Yes | Yes | Yes | Yes | Yes | |||
CONVERT_TZ() |
Yes | Yes | Yes | Yes | Yes | |||
ConvexHull() |
5.7.5 | 5.7.6 | Yes | |||||
COS() |
Yes | Yes | Yes | Yes | Yes | |||
COT() |
Yes | Yes | Yes | Yes | Yes | |||
COUNT() |
Yes | Yes | Yes | Yes | Yes | |||
COUNT(DISTINCT) |
Yes | Yes | Yes | Yes | Yes | |||
CRC32() |
Yes | Yes | Yes | Yes | Yes | |||
Crosses() |
5.7.6 | Yes | ||||||
CUME_DIST() |
8.0.2 | Yes | Yes | Yes | Yes | |||
CURDATE() |
Yes | Yes | Yes | Yes | Yes | |||
CURRENT_DATE(), CURRENT_DATE
|
Yes | Yes | Yes | Yes | Yes | |||
CURRENT_ROLE() |
Yes | Yes | Yes | Yes | ||||
CURRENT_TIME(), CURRENT_TIME
|
Yes | Yes | Yes | Yes | Yes | |||
CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP
|
Yes | Yes | Yes | Yes | Yes | |||
CURRENT_USER(), CURRENT_USER
|
Yes | Yes | Yes | Yes | Yes | |||
CURTIME() |
Yes | Yes | Yes | Yes | Yes | |||
DATABASE() |
Yes | Yes | Yes | Yes | Yes | |||
DATE() |
Yes | Yes | Yes | Yes | Yes | |||
DATE_ADD() |
Yes | Yes | Yes | Yes | Yes | |||
DATE_FORMAT() |
Yes | Yes | Yes | Yes | Yes | |||
DATE_SUB() |
Yes | Yes | Yes | Yes | Yes | |||
DATEDIFF() |
Yes | Yes | Yes | Yes | Yes | |||
DAY() |
Yes | Yes | Yes | Yes | Yes | |||
DAYNAME() |
Yes | Yes | Yes | Yes | Yes | |||
DAYOFMONTH() |
Yes | Yes | Yes | Yes | Yes | |||
DAYOFWEEK() |
Yes | Yes | Yes | Yes | Yes | |||
DAYOFYEAR() |
Yes | Yes | Yes | Yes | Yes | |||
DECODE() |
5.7.2 | 8.0.3 | Yes | |||||
DEFAULT() |
Yes | Yes | Yes | Yes | Yes | |||
DEGREES() |
Yes | Yes | Yes | Yes | Yes | |||
DENSE_RANK() |
8.0.2 | Yes | Yes | Yes | Yes | |||
DES_DECRYPT() |
5.7.6 | 8.0.3 | Yes | |||||
DES_ENCRYPT() |
5.7.6 | 8.0.3 | Yes | |||||
Dimension() |
5.7.6 | Yes | ||||||
Disjoint() |
5.7.6 | Yes | ||||||
Distance() |
5.7.5 | 5.7.6 | Yes | |||||
DIV |
Yes | Yes | Yes | Yes | Yes | |||
ELT() |
Yes | Yes | Yes | Yes | Yes | |||
ENCODE() |
5.7.2 | 8.0.3 | Yes | |||||
ENCRYPT() |
5.7.6 | 8.0.3 | Yes | |||||
EndPoint() |
5.7.6 | Yes | ||||||
Envelope() |
5.7.6 | Yes | ||||||
Equals() |
5.7.6 | Yes | ||||||
EXP() |
Yes | Yes | Yes | Yes | Yes | |||
EXPORT_SET() |
Yes | Yes | Yes | Yes | Yes | |||
ExteriorRing() |
5.7.6 | Yes | ||||||
EXTRACT() |
Yes | Yes | Yes | Yes | Yes | |||
ExtractValue() |
Yes | Yes | Yes | Yes | Yes | |||
FIELD() |
Yes | Yes | Yes | Yes | Yes | |||
FIND_IN_SET() |
Yes | Yes | Yes | Yes | Yes | |||
FIRST_VALUE() |
8.0.2 | Yes | Yes | Yes | Yes | |||
FLOOR() |
Yes | Yes | Yes | Yes | Yes | |||
FORMAT() |
Yes | Yes | Yes | Yes | Yes | |||
FORMAT_BYTES() |
8.0.16 | Some | Yes | Yes | Yes | |||
FORMAT_PICO_TIME() |
8.0.16 | Some | Yes | Yes | Yes | |||
FOUND_ROWS() |
Yes | Yes | Yes | Yes | Yes | |||
FROM_BASE64() |
Yes | Yes | ||||||
FROM_DAYS() |
Yes | Yes | Yes | Yes | Yes | |||
FROM_UNIXTIME() |
Yes | Yes | Yes | Yes | Yes | |||
GeomCollection() |
8.0.11 | Yes | Yes | Yes | Yes | |||
GeomCollFromText(), GeometryCollectionFromText()
|
5.7.6 | Yes | ||||||
GeomCollFromWKB(), GeometryCollectionFromWKB()
|
5.7.6 | Yes | ||||||
GeometryCollection() |
Yes | Yes | Yes | Yes | Yes | |||
GeometryN() |
5.7.6 | Yes | ||||||
GeometryType() |
5.7.6 | Yes | ||||||
GeomFromText(), GeometryFromText()
|
5.7.6 | Yes | ||||||
GeomFromWKB(), GeometryFromWKB()
|
5.7.6 | Yes | ||||||
GET_DD_COLUMN_PRIVILEGES() |
Yes | Yes | Yes | Yes | ||||
GET_DD_CREATE_OPTIONS() |
Yes | Yes | Yes | Yes | ||||
GET_DD_INDEX_SUB_PART_LENGTH() |
Yes | Yes | Yes | Yes | ||||
GET_FORMAT() |
Yes | Yes | Yes | Yes | Yes | |||
GET_LOCK() |
Yes | Yes | Yes | Yes | Yes | |||
GLength() |
5.7.6 | Yes | ||||||
GREATEST() |
Yes | Yes | Yes | Yes | Yes | |||
GROUP_CONCAT() |
Yes | Yes | Yes | Yes | Yes | |||
group_replication_disable_member_action() |
8.0.26 | Some | Yes | Yes | Yes | |||
group_replication_enable_member_action() |
8.0.26 | Some | Yes | Yes | Yes | |||
group_replication_get_communication_protocol() |
8.0.16 | Some | Yes | Yes | Yes | |||
group_replication_get_write_concurrency() |
8.0.13 | Some | Yes | Yes | Yes | |||
group_replication_reset_member_actions() |
8.0.26 | Some | Yes | Yes | Yes | |||
group_replication_set_as_primary() |
8.0.29 | Some | Yes | Yes | Yes | |||
group_replication_set_communication_protocol() |
8.0.16 | Some | Yes | Yes | Yes | |||
group_replication_set_write_concurrency() |
8.0.13 | Some | Yes | Yes | Yes | |||
group_replication_switch_to_multi_primary_mode() |
8.0.13 | Some | Yes | Yes | Yes | |||
group_replication_switch_to_single_primary_mode() |
8.0.13 | Some | Yes | Yes | Yes | |||
GROUPING() |
8.0.1 | Yes | Yes | Yes | Yes | |||
GTID_SUBSET() |
Yes | Yes | ||||||
GTID_SUBTRACT() |
Yes | Yes | ||||||
HEX() |
Yes | Yes | Yes | Yes | Yes | |||
HOUR() |
Yes | Yes | Yes | Yes | Yes | |||
ICU_VERSION() |
8.0.4 | Yes | Yes | Yes | Yes | |||
IF() |
Yes | Yes | Yes | Yes | Yes | |||
IFNULL() |
Yes | Yes | Yes | Yes | Yes | |||
IN() |
Yes | Yes | Yes | Yes | Yes | |||
INET_ATON() |
Yes | Yes | Yes | Yes | Yes | |||
INET_NTOA() |
Yes | Yes | Yes | Yes | Yes | |||
INET6_ATON() |
Yes | Yes | ||||||
INET6_NTOA() |
Yes | Yes | ||||||
INSERT() |
Yes | Yes | Yes | Yes | Yes | |||
INSTR() |
Yes | Yes | Yes | Yes | Yes | |||
InteriorRingN() |
5.7.6 | Yes | ||||||
INTERNAL_AUTO_INCREMENT() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_AVG_ROW_LENGTH() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_CHECK_TIME() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_CHECKSUM() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_DATA_FREE() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_DATA_LENGTH() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_DD_CHAR_LENGTH() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_GET_COMMENT_OR_ERROR() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_GET_ENABLED_ROLE_JSON() |
8.0.19 | Some | Yes | Yes | Yes | |||
INTERNAL_GET_HOSTNAME() |
8.0.19 | Some | Yes | Yes | Yes | |||
INTERNAL_GET_USERNAME() |
8.0.19 | Some | Yes | Yes | Yes | |||
INTERNAL_GET_VIEW_WARNING_OR_ERROR() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_INDEX_COLUMN_CARDINALITY() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_INDEX_LENGTH() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_IS_ENABLED_ROLE() |
8.0.19 | Some | Yes | Yes | Yes | |||
INTERNAL_IS_MANDATORY_ROLE() |
8.0.19 | Some | Yes | Yes | Yes | |||
INTERNAL_KEYS_DISABLED() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_MAX_DATA_LENGTH() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_TABLE_ROWS() |
Yes | Yes | Yes | Yes | ||||
INTERNAL_UPDATE_TIME() |
Yes | Yes | Yes | Yes | ||||
Intersects() |
5.7.6 | Yes | ||||||
INTERVAL() |
Yes | Yes | Yes | Yes | Yes | |||
IS |
Yes | Yes | Yes | Yes | Yes | |||
IS_FREE_LOCK() |
Yes | Yes | Yes | Yes | Yes | |||
IS_IPV4() |
Yes | Yes | ||||||
IS_IPV4_COMPAT() |
Yes | Yes | ||||||
IS_IPV4_MAPPED() |
Yes | Yes | ||||||
IS_IPV6() |
Yes | Yes | ||||||
IS NOT |
Yes | Yes | Yes | Yes | Yes | |||
IS NOT NULL |
Yes | Yes | Yes | Yes | Yes | |||
IS NULL |
Yes | Yes | Yes | Yes | Yes | |||
IS_USED_LOCK() |
Yes | Yes | Yes | Yes | Yes | |||
IS_UUID() |
Yes | Yes | Yes | Yes | ||||
IsClosed() |
5.7.6 | Yes | ||||||
IsEmpty() |
5.7.6 | Yes | ||||||
ISNULL() |
Yes | Yes | Yes | Yes | Yes | |||
IsSimple() |
5.7.6 | Yes | ||||||
JSON_APPEND() |
5.7.8 | 5.7.9 | Yes | |||||
JSON_ARRAY() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_ARRAY_APPEND() |
5.7.9 | Yes | Yes | Yes | Yes | Yes | ||
JSON_ARRAY_INSERT() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_ARRAYAGG() |
5.7.22, 8.0.1 | Some | Yes | Yes | Yes | Yes | ||
JSON_CONTAINS() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_CONTAINS_PATH() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_DEPTH() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_EXTRACT() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_INSERT() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_KEYS() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_LENGTH() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_MERGE() |
5.7.8 | 5.7.22, 8.0.3 | Yes | Yes | Yes | Yes | Yes | |
JSON_MERGE_PATCH() |
5.7.22, 8.0.3 | Some | Yes | Yes | Yes | Yes | ||
JSON_MERGE_PRESERVE() |
5.7.22, 8.0.3 | Some | Yes | Yes | Yes | Yes | ||
JSON_OBJECT() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_OBJECTAGG() |
5.7.22, 8.0.1 | Some | Yes | Yes | Yes | Yes | ||
JSON_OVERLAPS() |
8.0.17 | Some | Yes | Yes | Yes | |||
JSON_PRETTY() |
5.7.22, 8.0.1 | Some | Yes | Yes | Yes | Yes | ||
JSON_QUOTE() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_REMOVE() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_REPLACE() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_SCHEMA_VALID() |
8.0.17 | Some | Yes | Yes | Yes | |||
JSON_SCHEMA_VALIDATION_REPORT() |
8.0.17 | Some | Yes | Yes | Yes | |||
JSON_SEARCH() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_SET() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_STORAGE_FREE() |
8.0.2 | Yes | Yes | Yes | Yes | |||
JSON_STORAGE_SIZE() |
5.7.22, 8.0.2 | Some | Yes | Yes | Yes | Yes | ||
JSON_TABLE() |
8.0.4 | Yes | Yes | Yes | Yes | |||
JSON_TYPE() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_UNQUOTE() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_VALID() |
5.7.8 | Yes | Yes | Yes | Yes | Yes | ||
JSON_VALUE() |
8.0.21 | Some | Yes | Yes | Yes | |||
LAG() |
8.0.2 | Yes | Yes | Yes | Yes | |||
LAST_DAY |
Yes | Yes | Yes | Yes | Yes | |||
LAST_INSERT_ID() |
Yes | Yes | Yes | Yes | Yes | |||
LAST_VALUE() |
8.0.2 | Yes | Yes | Yes | Yes | |||
LCASE() |
Yes | Yes | Yes | Yes | Yes | |||
LEAD() |
8.0.2 | Yes | Yes | Yes | Yes | |||
LEAST() |
Yes | Yes | Yes | Yes | Yes | |||
LEFT() |
Yes | Yes | Yes | Yes | Yes | |||
LENGTH() |
Yes | Yes | Yes | Yes | Yes | |||
LIKE |
Yes | Yes | Yes | Yes | Yes | |||
LineFromText(), LineStringFromText()
|
5.7.6 | Yes | ||||||
LineFromWKB(), LineStringFromWKB()
|
5.7.6 | Yes | ||||||
LineString() |
Yes | Yes | Yes | Yes | Yes | |||
LN() |
Yes | Yes | Yes | Yes | Yes | |||
LOAD_FILE() |
Yes | Yes | Yes | Yes | Yes | |||
LOCALTIME(), LOCALTIME
|
Yes | Yes | Yes | Yes | Yes | |||
LOCALTIMESTAMP, LOCALTIMESTAMP()
|
Yes | Yes | Yes | Yes | Yes | |||
LOCATE() |
Yes | Yes | Yes | Yes | Yes | |||
LOG() |
Yes | Yes | Yes | Yes | Yes | |||
LOG10() |
Yes | Yes | Yes | Yes | Yes | |||
LOG2() |
Yes | Yes | Yes | Yes | Yes | |||
LOWER() |
Yes | Yes | Yes | Yes | Yes | |||
LPAD() |
Yes | Yes | Yes | Yes | Yes | |||
LTRIM() |
Yes | Yes | Yes | Yes | Yes | |||
MAKE_SET() |
Yes | Yes | Yes | Yes | Yes | |||
MAKEDATE() |
Yes | Yes | Yes | Yes | Yes | |||
MAKETIME() |
Yes | Yes | Yes | Yes | Yes | |||
MASTER_POS_WAIT() |
8.0.26 | Yes | Yes | Yes | Yes | Yes | ||
MATCH() |
Yes | Yes | Yes | Yes | Yes | |||
MAX() |
Yes | Yes | Yes | Yes | Yes | |||
MBRContains() |
Yes | Yes | Yes | Yes | Yes | |||
MBRCoveredBy() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
MBRCovers() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
MBRDisjoint() |
Yes | Yes | Yes | Yes | Yes | |||
MBREqual() |
5.7.6 | Yes | ||||||
MBREquals() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
MBRIntersects() |
Yes | Yes | Yes | Yes | Yes | |||
MBROverlaps() |
Yes | Yes | Yes | Yes | Yes | |||
MBRTouches() |
Yes | Yes | Yes | Yes | Yes | |||
MBRWithin() |
Yes | Yes | Yes | Yes | Yes | |||
MD5() |
Yes | Yes | Yes | Yes | Yes | |||
MEMBER OF() |
8.0.17 | Some | Yes | Yes | Yes | |||
MICROSECOND() |
Yes | Yes | Yes | Yes | Yes | |||
MID() |
Yes | Yes | Yes | Yes | Yes | |||
MIN() |
Yes | Yes | Yes | Yes | Yes | |||
MINUTE() |
Yes | Yes | Yes | Yes | Yes | |||
MLineFromText(), MultiLineStringFromText()
|
5.7.6 | Yes | ||||||
MLineFromWKB(), MultiLineStringFromWKB()
|
5.7.6 | Yes | ||||||
MOD() |
Yes | Yes | Yes | Yes | Yes | |||
MONTH() |
Yes | Yes | Yes | Yes | Yes | |||
MONTHNAME() |
Yes | Yes | Yes | Yes | Yes | |||
MPointFromText(), MultiPointFromText()
|
5.7.6 | Yes | ||||||
MPointFromWKB(), MultiPointFromWKB()
|
5.7.6 | Yes | ||||||
MPolyFromText(), MultiPolygonFromText()
|
5.7.6 | Yes | ||||||
MPolyFromWKB(), MultiPolygonFromWKB()
|
5.7.6 | Yes | ||||||
MultiLineString() |
Yes | Yes | Yes | Yes | Yes | |||
MultiPoint() |
Yes | Yes | Yes | Yes | Yes | |||
MultiPolygon() |
Yes | Yes | Yes | Yes | Yes | |||
NAME_CONST() |
Yes | Yes | Yes | Yes | Yes | |||
NOT, !
|
Yes | Yes | Yes | Yes | Yes | |||
NOT BETWEEN ... AND ... |
Yes | Yes | Yes | Yes | Yes | |||
NOT IN() |
Yes | Yes | Yes | Yes | Yes | |||
NOT LIKE |
Yes | Yes | Yes | Yes | Yes | |||
NOT REGEXP |
Yes | Yes | Yes | Yes | Yes | |||
NOW() |
Yes | Yes | Yes | Yes | Yes | |||
NTH_VALUE() |
8.0.2 | Yes | Yes | Yes | Yes | |||
NTILE() |
8.0.2 | Yes | Yes | Yes | Yes | |||
NULLIF() |
Yes | Yes | Yes | Yes | Yes | |||
NumGeometries() |
5.7.6 | Yes | ||||||
NumInteriorRings() |
5.7.6 | Yes | ||||||
NumPoints() |
5.7.6 | Yes | ||||||
OCT() |
Yes | Yes | Yes | Yes | Yes | |||
OCTET_LENGTH() |
Yes | Yes | Yes | Yes | Yes | |||
OLD_PASSWORD() |
5.6.5 | 5.7.5 | ||||||
OR, ||
|
Yes | Yes | Yes | Yes | Yes | |||
ORD() |
Yes | Yes | Yes | Yes | Yes | |||
Overlaps() |
5.7.6 | Yes | ||||||
PASSWORD() |
5.7.6 | 8.0.11 | Yes | |||||
PERCENT_RANK() |
8.0.2 | Yes | Yes | Yes | Yes | |||
PERIOD_ADD() |
Yes | Yes | Yes | Yes | Yes | |||
PERIOD_DIFF() |
Yes | Yes | Yes | Yes | Yes | |||
PI() |
Yes | Yes | Yes | Yes | Yes | |||
Point() |
Yes | Yes | Yes | Yes | Yes | |||
PointFromText() |
5.7.6 | Yes | ||||||
PointFromWKB() |
5.7.6 | Yes | ||||||
PointN() |
5.7.6 | Yes | ||||||
PolyFromText(), PolygonFromText()
|
5.7.6 | Yes | ||||||
PolyFromWKB(), PolygonFromWKB()
|
5.7.6 | Yes | ||||||
Polygon() |
Yes | Yes | Yes | Yes | Yes | |||
POSITION() |
Yes | Yes | Yes | Yes | Yes | |||
POW() |
Yes | Yes | Yes | Yes | Yes | |||
POWER() |
Yes | Yes | Yes | Yes | Yes | |||
PROCEDURE ANALYSE() |
5.7.18 | Yes | ||||||
PS_CURRENT_THREAD_ID() |
8.0.16 | Some | Yes | Yes | Yes | |||
PS_THREAD_ID() |
8.0.16 | Some | Yes | Yes | Yes | |||
QUARTER() |
Yes | Yes | Yes | Yes | Yes | |||
QUOTE() |
Yes | Yes | Yes | Yes | Yes | |||
RADIANS() |
Yes | Yes | Yes | Yes | Yes | |||
RAND() |
Yes | Yes | Yes | Yes | Yes | |||
RANDOM_BYTES() |
5.7.4 | Yes | Yes | Yes | Yes | Yes | ||
RANK() |
8.0.2 | Yes | Yes | Yes | Yes | |||
REGEXP |
Yes | Yes | Yes | Yes | Yes | |||
REGEXP_INSTR() |
8.0.4 | Yes | Yes | Yes | Yes | |||
REGEXP_LIKE() |
8.0.4 | Yes | Yes | Yes | Yes | |||
REGEXP_REPLACE() |
8.0.4 | Yes | Yes | Yes | Yes | |||
REGEXP_SUBSTR() |
8.0.4 | Yes | Yes | Yes | Yes | |||
RELEASE_ALL_LOCKS() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
RELEASE_LOCK() |
Yes | Yes | Yes | Yes | Yes | |||
REPEAT() |
Yes | Yes | Yes | Yes | Yes | |||
REPLACE() |
Yes | Yes | Yes | Yes | Yes | |||
REVERSE() |
Yes | Yes | Yes | Yes | Yes | |||
RIGHT() |
Yes | Yes | Yes | Yes | Yes | |||
RLIKE |
Yes | Yes | Yes | Yes | Yes | |||
ROLES_GRAPHML() |
Yes | Yes | Yes | Yes | ||||
ROUND() |
Yes | Yes | Yes | Yes | Yes | |||
ROW_COUNT() |
Yes | Yes | Yes | Yes | Yes | |||
ROW_NUMBER() |
8.0.2 | Yes | Yes | Yes | Yes | |||
RPAD() |
Yes | Yes | Yes | Yes | Yes | |||
RTRIM() |
Yes | Yes | Yes | Yes | Yes | |||
SCHEMA() |
Yes | Yes | Yes | Yes | Yes | |||
SEC_TO_TIME() |
Yes | Yes | Yes | Yes | Yes | |||
SECOND() |
Yes | Yes | Yes | Yes | Yes | |||
SESSION_USER() |
Yes | Yes | Yes | Yes | Yes | |||
SHA1(), SHA()
|
Yes | Yes | Yes | Yes | Yes | |||
SHA2() |
Yes | Yes | Yes | Yes | Yes | |||
SIGN() |
Yes | Yes | Yes | Yes | Yes | |||
SIN() |
Yes | Yes | Yes | Yes | Yes | |||
SLEEP() |
Yes | Yes | Yes | Yes | Yes | |||
SOUNDEX() |
Yes | Yes | Yes | Yes | Yes | |||
SOUNDS LIKE |
Yes | Yes | Yes | Yes | Yes | |||
SOURCE_POS_WAIT() |
8.0.26 | Some | Yes | Yes | Yes | |||
SPACE() |
Yes | Yes | Yes | Yes | Yes | |||
SQRT() |
Yes | Yes | Yes | Yes | Yes | |||
SRID() |
5.7.6 | Yes | ||||||
ST_Area() |
Yes | Yes | Yes | Yes | Yes | |||
ST_AsBinary(), ST_AsWKB()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_AsGeoJSON() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
ST_AsText(), ST_AsWKT()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_Buffer() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Buffer_Strategy() |
5.7.7 | Yes | Yes | Yes | Yes | Yes | ||
ST_Centroid() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Collect() |
8.0.24 | Some | Yes | Yes | Yes | |||
ST_Contains() |
Yes | Yes | Yes | Yes | Yes | |||
ST_ConvexHull() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
ST_Crosses() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Difference() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Dimension() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Disjoint() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Distance() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Distance_Sphere() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_EndPoint() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Envelope() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Equals() |
Yes | Yes | Yes | Yes | Yes | |||
ST_ExteriorRing() |
Yes | Yes | Yes | Yes | Yes | |||
ST_FrechetDistance() |
8.0.23 | Some | Yes | Yes | Yes | |||
ST_GeoHash() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
ST_GeomCollFromText(), ST_GeometryCollectionFromText(), ST_GeomCollFromTxt()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_GeomCollFromWKB(), ST_GeometryCollectionFromWKB()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_GeometryN() |
Yes | Yes | Yes | Yes | Yes | |||
ST_GeometryType() |
Yes | Yes | Yes | Yes | Yes | |||
ST_GeomFromGeoJSON() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
ST_GeomFromText(), ST_GeometryFromText()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_GeomFromWKB(), ST_GeometryFromWKB()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_HausdorffDistance() |
8.0.23 | Some | Yes | Yes | Yes | |||
ST_InteriorRingN() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Intersection() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Intersects() |
Yes | Yes | Yes | Yes | Yes | |||
ST_IsClosed() |
Yes | Yes | Yes | Yes | Yes | |||
ST_IsEmpty() |
Yes | Yes | Yes | Yes | Yes | |||
ST_IsSimple() |
Yes | Yes | Yes | Yes | Yes | |||
ST_IsValid() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_LatFromGeoHash() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
ST_Latitude() |
8.0.12 | Some | Yes | Yes | Yes | |||
ST_Length() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_LineFromText(), ST_LineStringFromText()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_LineFromWKB(), ST_LineStringFromWKB()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_LineInterpolatePoint() |
8.0.24 | Some | Yes | Yes | Yes | |||
ST_LineInterpolatePoints() |
8.0.24 | Some | Yes | Yes | Yes | |||
ST_LongFromGeoHash() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
ST_Longitude() |
8.0.12 | Some | Yes | Yes | Yes | |||
ST_MakeEnvelope() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_MLineFromText(), ST_MultiLineStringFromText()
|
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_MLineFromWKB(), ST_MultiLineStringFromWKB()
|
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_MPointFromText(), ST_MultiPointFromText()
|
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_MPointFromWKB(), ST_MultiPointFromWKB()
|
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_MPolyFromText(), ST_MultiPolygonFromText()
|
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_MPolyFromWKB(), ST_MultiPolygonFromWKB()
|
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_NumGeometries() |
Yes | Yes | Yes | Yes | Yes | |||
ST_NumInteriorRing(), ST_NumInteriorRings()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_NumPoints() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Overlaps() |
Yes | Yes | Yes | Yes | Yes | |||
ST_PointAtDistance() |
8.0.24 | Some | Yes | Yes | Yes | |||
ST_PointFromGeoHash() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
ST_PointFromText() |
Yes | Yes | Yes | Yes | Yes | |||
ST_PointFromWKB() |
Yes | Yes | Yes | Yes | Yes | |||
ST_PointN() |
Yes | Yes | Yes | Yes | Yes | |||
ST_PolyFromText(), ST_PolygonFromText()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_PolyFromWKB(), ST_PolygonFromWKB()
|
Yes | Yes | Yes | Yes | Yes | |||
ST_Simplify() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_SRID() |
Yes | Yes | Yes | Yes | Yes | |||
ST_StartPoint() |
Yes | Yes | Yes | Yes | Yes | |||
ST_SwapXY() |
8.0.1 | Yes | Yes | Yes | Yes | |||
ST_SymDifference() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Touches() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Transform() |
8.0.13 | Some | Yes | Yes | Yes | |||
ST_Union() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Validate() |
5.7.6 | Yes | Yes | Yes | Yes | Yes | ||
ST_Within() |
Yes | Yes | Yes | Yes | Yes | |||
ST_X() |
Yes | Yes | Yes | Yes | Yes | |||
ST_Y() |
Yes | Yes | Yes | Yes | Yes | |||
StartPoint() |
5.7.6 | Yes | ||||||
STATEMENT_DIGEST() |
8.0.4 | Yes | Yes | Yes | Yes | |||
STATEMENT_DIGEST_TEXT() |
8.0.4 | Yes | Yes | Yes | Yes | |||
STD() |
Yes | Yes | Yes | Yes | Yes | |||
STDDEV() |
Yes | Yes | Yes | Yes | Yes | |||
STDDEV_POP() |
Yes | Yes | Yes | Yes | Yes | |||
STDDEV_SAMP() |
Yes | Yes | Yes | Yes | Yes | |||
STR_TO_DATE() |
Yes | Yes | Yes | Yes | Yes | |||
STRCMP() |
Yes | Yes | Yes | Yes | Yes | |||
SUBDATE() |
Yes | Yes | Yes | Yes | Yes | |||
SUBSTR() |
Yes | Yes | Yes | Yes | Yes | |||
SUBSTRING() |
Yes | Yes | Yes | Yes | Yes | |||
SUBSTRING_INDEX() |
Yes | Yes | Yes | Yes | Yes | |||
SUBTIME() |
Yes | Yes | Yes | Yes | Yes | |||
SUM() |
Yes | Yes | Yes | Yes | Yes | |||
SYSDATE() |
Yes | Yes | Yes | Yes | Yes | |||
SYSTEM_USER() |
Yes | Yes | Yes | Yes | Yes | |||
TAN() |
Yes | Yes | Yes | Yes | Yes | |||
TIME() |
Yes | Yes | Yes | Yes | Yes | |||
TIME_FORMAT() |
Yes | Yes | Yes | Yes | Yes | |||
TIME_TO_SEC() |
Yes | Yes | Yes | Yes | Yes | |||
TIMEDIFF() |
Yes | Yes | Yes | Yes | Yes | |||
TIMESTAMP() |
Yes | Yes | Yes | Yes | Yes | |||
TIMESTAMPADD() |
Yes | Yes | Yes | Yes | Yes | |||
TIMESTAMPDIFF() |
Yes | Yes | Yes | Yes | Yes | |||
TO_BASE64() |
Yes | Yes | ||||||
TO_DAYS() |
Yes | Yes | Yes | Yes | Yes | |||
TO_SECONDS() |
Yes | Yes | Yes | Yes | Yes | |||
Touches() |
5.7.6 | Yes | ||||||
TRIM() |
Yes | Yes | Yes | Yes | Yes | |||
TRUNCATE() |
Yes | Yes | Yes | Yes | Yes | |||
UCASE() |
Yes | Yes | Yes | Yes | Yes | |||
UNCOMPRESS() |
Yes | Yes | Yes | Yes | Yes | |||
UNCOMPRESSED_LENGTH() |
Yes | Yes | Yes | Yes | Yes | |||
UNHEX() |
Yes | Yes | Yes | Yes | Yes | |||
UNIX_TIMESTAMP() |
Yes | Yes | Yes | Yes | Yes | |||
UpdateXML() |
Yes | Yes | Yes | Yes | Yes | |||
UPPER() |
Yes | Yes | Yes | Yes | Yes | |||
USER() |
Yes | Yes | Yes | Yes | Yes | |||
UTC_DATE() |
Yes | Yes | Yes | Yes | Yes | |||
UTC_TIME() |
Yes | Yes | Yes | Yes | Yes | |||
UTC_TIMESTAMP() |
Yes | Yes | Yes | Yes | Yes | |||
UUID() |
Yes | Yes | Yes | Yes | Yes | |||
UUID_SHORT() |
Yes | Yes | Yes | Yes | Yes | |||
UUID_TO_BIN() |
Yes | Yes | Yes | Yes | ||||
VALIDATE_PASSWORD_STRENGTH() |
Yes | Yes | Yes | Yes | Yes | |||
VALUES() |
Yes | Yes | Yes | Yes | Yes | |||
VAR_POP() |
Yes | Yes | Yes | Yes | Yes | |||
VAR_SAMP() |
Yes | Yes | Yes | Yes | Yes | |||
VARIANCE() |
Yes | Yes | Yes | Yes | Yes | |||
VERSION() |
Yes | Yes | Yes | Yes | Yes | |||
WAIT_FOR_EXECUTED_GTID_SET() |
5.7.5 | Yes | Yes | Yes | Yes | Yes | ||
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() |
8.0.18 | Yes | Yes | Yes | ||||
WEEK() |
Yes | Yes | Yes | Yes | Yes | |||
WEEKDAY() |
Yes | Yes | Yes | Yes | Yes | |||
WEEKOFYEAR() |
Yes | Yes | Yes | Yes | Yes | |||
WEIGHT_STRING() |
Yes | Yes | Yes | Yes | Yes | |||
Within() |
5.7.6 | Yes | ||||||
X() |
5.7.6 | Yes | ||||||
XOR |
Yes | Yes | Yes | Yes | Yes | |||
Y() |
5.7.6 | Yes | ||||||
YEAR() |
Yes | Yes | Yes | Yes | Yes | |||
YEARWEEK() |
Yes | Yes | Yes | Yes | Yes | |||
| |
Yes | Yes | Yes | Yes | Yes | |||
~ |
Yes | Yes | Yes | Yes | Yes |