PDF (US Ltr)
- 4.3Mb
PDF (A4)
- 4.3Mb
The following table shows all built-in functions and operators available in MySQL Server. 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.
-
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 | 8.0 | 8.4 | 9.7 | 26.7 |
|---|---|---|---|---|---|---|---|
& |
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 | 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 | |||
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() |
Yes | Yes | Yes | Yes | |||
ASCII() |
Yes | Yes | Yes | Yes | |||
ASIN() |
Yes | Yes | Yes | Yes | |||
asynchronous_connection_failover_add_managed() |
8.0.23 | Yes | Yes | Yes | Yes | ||
asynchronous_connection_failover_add_source() |
8.0.22 | Yes | Yes | Yes | Yes | ||
asynchronous_connection_failover_delete_managed() |
8.0.23 | Yes | Yes | Yes | Yes | ||
asynchronous_connection_failover_delete_source() |
8.0.22 | Yes | Yes | Yes | Yes | ||
asynchronous_connection_failover_reset() |
8.0.27 | Yes | 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 | Yes | Yes | Yes | |||
BINARY |
8.0.27 | 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 | |||
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 | Yes | Yes | Yes | Yes | ||
CAN_ACCESS_VIEW() |
Yes | Yes | Yes | Yes | |||
CASE |
Yes | Yes | Yes | Yes | |||
CAST() |
Yes | Yes | Yes | Yes | |||
CEIL() |
Yes | Yes | Yes | Yes | |||
CEILING() |
Yes | 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 | |||
CONV() |
Yes | Yes | Yes | Yes | |||
CONVERT() |
Yes | Yes | Yes | Yes | |||
CONVERT_TZ() |
Yes | Yes | Yes | 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 | |||
CUME_DIST() |
8.0.2 | Yes | Yes | Yes | Yes | ||
CURDATE() |
Yes | Yes | Yes | Yes | |||
CURRENT_DATE(), CURRENT_DATE
|
Yes | Yes | Yes | Yes | |||
CURRENT_ROLE() |
Yes | Yes | Yes | 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 | 8.0.3 | |||||
DEFAULT() |
Yes | Yes | Yes | Yes | |||
DEGREES() |
Yes | Yes | Yes | Yes | |||
DENSE_RANK() |
8.0.2 | Yes | Yes | Yes | Yes | ||
DES_DECRYPT() |
5.7.6 | 8.0.3 | |||||
DES_ENCRYPT() |
5.7.6 | 8.0.3 | |||||
DISTANCE() |
Yes | Yes | |||||
DIV |
Yes | Yes | Yes | Yes | |||
ELT() |
Yes | Yes | Yes | Yes | |||
ENCODE() |
5.7.2 | 8.0.3 | |||||
ENCRYPT() |
5.7.6 | 8.0.3 | |||||
ETAG() |
Yes | Yes | |||||
EXISTS() |
Yes | Yes | Yes | Yes | |||
EXP() |
Yes | Yes | Yes | Yes | |||
EXPORT_SET() |
Yes | 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 | Yes | Yes | Yes | ||
FLOOR() |
Yes | Yes | Yes | Yes | |||
FORMAT() |
Yes | Yes | Yes | Yes | |||
FORMAT_BYTES() |
8.0.16 | Yes | Yes | Yes | Yes | ||
FORMAT_PICO_TIME() |
8.0.16 | Yes | Yes | Yes | Yes | ||
FOUND_ROWS() |
Yes | Yes | Yes | Yes | |||
FROM_BASE64() |
Yes | Yes | Yes | Yes | |||
FROM_DAYS() |
Yes | Yes | Yes | Yes | |||
FROM_UNIXTIME() |
Yes | Yes | Yes | Yes | |||
GeomCollection() |
8.0.11 | Yes | Yes | Yes | Yes | ||
GeometryCollection() |
Yes | Yes | Yes | 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 | |||
GET_LOCK() |
Yes | Yes | Yes | Yes | |||
GREATEST() |
Yes | Yes | Yes | Yes | |||
GROUP_CONCAT() |
Yes | Yes | Yes | Yes | |||
group_replication_disable_member_action() |
8.0.26 | Yes | Yes | Yes | Yes | ||
group_replication_enable_member_action() |
8.0.26 | Yes | Yes | Yes | Yes | ||
group_replication_get_communication_protocol() |
8.0.16 | Yes | Yes | Yes | Yes | ||
group_replication_get_write_concurrency() |
8.0.13 | Yes | Yes | Yes | Yes | ||
group_replication_reset_member_actions() |
8.0.26 | Yes | Yes | Yes | Yes | ||
group_replication_set_as_primary() |
8.0.29 | Yes | Yes | Yes | Yes | ||
group_replication_set_communication_protocol() |
8.0.16 | Yes | Yes | Yes | Yes | ||
group_replication_set_write_concurrency() |
8.0.13 | Yes | Yes | Yes | Yes | ||
group_replication_switch_to_multi_primary_mode() |
8.0.13 | Yes | Yes | Yes | Yes | ||
group_replication_switch_to_single_primary_mode() |
8.0.13 | Yes | Yes | Yes | Yes | ||
GROUPING() |
8.0.1 | Yes | Yes | Yes | Yes | ||
GTID_SUBSET() |
Yes | ||||||
GTID_SUBTRACT() |
Yes | ||||||
HEX() |
Yes | Yes | Yes | Yes | |||
HOUR() |
Yes | Yes | Yes | Yes | |||
ICU_VERSION() |
8.0.4 | Yes | Yes | Yes | 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() |
Yes | ||||||
INET6_NTOA() |
Yes | ||||||
INSERT() |
Yes | Yes | Yes | Yes | |||
INSTR() |
Yes | Yes | Yes | 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 | Yes | Yes | Yes | Yes | ||
INTERNAL_GET_HOSTNAME() |
8.0.19 | Yes | Yes | Yes | Yes | ||
INTERNAL_GET_USERNAME() |
8.0.19 | Yes | 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 | Yes | Yes | Yes | Yes | ||
INTERNAL_IS_MANDATORY_ROLE() |
8.0.19 | Yes | 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 | |||
INTERVAL() |
Yes | Yes | Yes | Yes | |||
IS |
Yes | Yes | Yes | Yes | |||
IS_FREE_LOCK() |
Yes | Yes | Yes | Yes | |||
IS_IPV4() |
Yes | ||||||
IS_IPV4_COMPAT() |
Yes | ||||||
IS_IPV4_MAPPED() |
Yes | ||||||
IS_IPV6() |
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 | Yes | Yes | Yes | |||
ISNULL() |
Yes | Yes | Yes | Yes | |||
JSON_ARRAY() |
Yes | Yes | Yes | Yes | |||
JSON_ARRAY_APPEND() |
Yes | Yes | Yes | Yes | |||
JSON_ARRAY_INSERT() |
Yes | Yes | Yes | Yes | |||
JSON_ARRAYAGG() |
8.0.1 | Yes | Yes | Yes | Yes | ||
JSON_CONTAINS() |
Yes | Yes | Yes | Yes | |||
JSON_CONTAINS_PATH() |
Yes | Yes | Yes | Yes | |||
JSON_DEPTH() |
Yes | Yes | Yes | Yes | |||
JSON_DUALITY_OBJECT() |
Yes | Yes | |||||
JSON_EXTRACT() |
Yes | Yes | Yes | Yes | |||
JSON_INSERT() |
Yes | Yes | Yes | Yes | |||
JSON_KEYS() |
Yes | Yes | Yes | Yes | |||
JSON_LENGTH() |
Yes | Yes | Yes | Yes | |||
JSON_MERGE() |
5.7.22, 8.0.3 | Yes | Yes | Yes | Yes | ||
JSON_MERGE_PATCH() |
8.0.3 | Yes | Yes | Yes | Yes | ||
JSON_MERGE_PRESERVE() |
8.0.3 | Yes | Yes | Yes | Yes | ||
JSON_OBJECT() |
Yes | Yes | Yes | Yes | |||
JSON_OBJECTAGG() |
8.0.1 | Yes | Yes | Yes | Yes | ||
JSON_OVERLAPS() |
8.0.17 | Yes | Yes | Yes | Yes | ||
JSON_PRETTY() |
8.0.1 | Yes | Yes | Yes | Yes | ||
JSON_QUOTE() |
Yes | Yes | Yes | Yes | |||
JSON_REMOVE() |
Yes | Yes | Yes | Yes | |||
JSON_REPLACE() |
Yes | Yes | Yes | Yes | |||
JSON_SCHEMA_VALID() |
8.0.17 | Yes | Yes | Yes | Yes | ||
JSON_SCHEMA_VALIDATION_REPORT() |
8.0.17 | Yes | Yes | Yes | Yes | ||
JSON_SEARCH() |
Yes | Yes | Yes | Yes | |||
JSON_SET() |
Yes | Yes | Yes | Yes | |||
JSON_STORAGE_FREE() |
8.0.2 | Yes | Yes | Yes | Yes | ||
JSON_STORAGE_SIZE() |
8.0.2 | Yes | Yes | Yes | Yes | ||
JSON_TABLE() |
8.0.4 | Yes | Yes | Yes | Yes | ||
JSON_TYPE() |
Yes | Yes | Yes | Yes | |||
JSON_UNQUOTE() |
Yes | Yes | Yes | Yes | |||
JSON_VALID() |
Yes | Yes | Yes | Yes | |||
JSON_VALUE() |
8.0.21 | Yes | Yes | Yes | Yes | ||
LAG() |
8.0.2 | Yes | Yes | Yes | Yes | ||
LAST_DAY |
Yes | Yes | Yes | Yes | |||
LAST_INSERT_ID() |
Yes | Yes | Yes | Yes | |||
LAST_VALUE() |
8.0.2 | Yes | Yes | Yes | Yes | ||
LCASE() |
Yes | Yes | Yes | Yes | |||
LEAD() |
8.0.2 | Yes | Yes | Yes | Yes | ||
LEAST() |
Yes | Yes | Yes | Yes | |||
LEFT() |
Yes | Yes | Yes | Yes | |||
LENGTH() |
Yes | Yes | Yes | Yes | |||
LIKE |
Yes | 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() |
8.0.26 | Yes | Yes | Yes | Yes | ||
MATCH() |
Yes | Yes | Yes | Yes | |||
MAX() |
Yes | Yes | Yes | Yes | |||
MBRContains() |
Yes | Yes | Yes | Yes | |||
MBRCoveredBy() |
Yes | Yes | Yes | Yes | |||
MBRCovers() |
Yes | Yes | Yes | Yes | |||
MBRDisjoint() |
Yes | Yes | Yes | Yes | |||
MBREquals() |
Yes | Yes | Yes | Yes | |||
MBRIntersects() |
Yes | Yes | Yes | Yes | |||
MBROverlaps() |
Yes | Yes | Yes | Yes | |||
MBRTouches() |
Yes | Yes | Yes | Yes | |||
MBRWithin() |
Yes | Yes | Yes | Yes | |||
MD5() |
9.4.0 | Yes | Yes | ||||
MEMBER OF() |
8.0.17 | Yes | Yes | Yes | Yes | ||
MICROSECOND() |
Yes | Yes | Yes | Yes | |||
MID() |
Yes | Yes | Yes | Yes | |||
MIN() |
Yes | Yes | Yes | Yes | |||
MINUTE() |
Yes | Yes | Yes | Yes | |||
MOD() |
Yes | Yes | Yes | Yes | |||
MONTH() |
Yes | Yes | Yes | Yes | |||
MONTHNAME() |
Yes | 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 | |||
NOT EXISTS() |
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 | Yes | Yes | Yes | ||
NTILE() |
8.0.2 | Yes | Yes | Yes | Yes | ||
NULLIF() |
Yes | Yes | Yes | Yes | |||
OCT() |
Yes | Yes | Yes | Yes | |||
OCTET_LENGTH() |
Yes | Yes | Yes | Yes | |||
OR, ||
|
Yes | Yes | Yes | Yes | |||
ORD() |
Yes | Yes | Yes | Yes | |||
PASSWORD() |
5.7.6 | 8.0.11 | |||||
PERCENT_RANK() |
8.0.2 | Yes | Yes | Yes | Yes | ||
PERIOD_ADD() |
Yes | Yes | Yes | Yes | |||
PERIOD_DIFF() |
Yes | Yes | Yes | Yes | |||
PI() |
Yes | Yes | Yes | Yes | |||
Point() |
Yes | Yes | Yes | Yes | |||
Polygon() |
Yes | Yes | Yes | Yes | |||
POSITION() |
Yes | Yes | Yes | Yes | |||
POW() |
Yes | Yes | Yes | Yes | |||
POWER() |
Yes | Yes | Yes | Yes | |||
PS_CURRENT_THREAD_ID() |
8.0.16 | Yes | Yes | Yes | Yes | ||
PS_THREAD_ID() |
8.0.16 | Yes | Yes | Yes | Yes | ||
QUARTER() |
Yes | Yes | Yes | Yes | |||
QUOTE() |
Yes | Yes | Yes | Yes | |||
RADIANS() |
Yes | Yes | Yes | Yes | |||
RAND() |
Yes | Yes | Yes | Yes | |||
RANDOM_BYTES() |
Yes | Yes | Yes | Yes | |||
RANK() |
8.0.2 | Yes | Yes | Yes | Yes | ||
REGEXP |
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() |
Yes | Yes | 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 | |||
RLIKE |
Yes | Yes | Yes | Yes | |||
ROLES_GRAPHML() |
Yes | Yes | Yes | Yes | |||
ROUND() |
Yes | Yes | Yes | Yes | |||
ROW_COUNT() |
Yes | Yes | Yes | Yes | |||
ROW_NUMBER() |
8.0.2 | Yes | Yes | Yes | 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()
|
9.4.0 | Yes | Yes | ||||
SHA2() |
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 | |||
SOURCE_POS_WAIT() |
8.0.26 | Yes | Yes | Yes | Yes | ||
SPACE() |
Yes | Yes | Yes | Yes | |||
SQRT() |
Yes | Yes | Yes | Yes | |||
ST_Area() |
Yes | Yes | Yes | Yes | |||
ST_AsBinary(), ST_AsWKB()
|
Yes | Yes | Yes | Yes | |||
ST_AsGeoJSON() |
Yes | Yes | Yes | Yes | |||
ST_AsText(), ST_AsWKT()
|
Yes | Yes | Yes | Yes | |||
ST_Buffer() |
Yes | Yes | Yes | Yes | |||
ST_Buffer_Strategy() |
Yes | Yes | Yes | Yes | |||
ST_Centroid() |
Yes | Yes | Yes | Yes | |||
ST_Collect() |
8.0.24 | Yes | Yes | Yes | Yes | ||
ST_Contains() |
Yes | Yes | Yes | Yes | |||
ST_ConvexHull() |
Yes | Yes | Yes | Yes | |||
ST_Crosses() |
Yes | Yes | Yes | Yes | |||
ST_Difference() |
Yes | Yes | Yes | Yes | |||
ST_Dimension() |
Yes | Yes | Yes | Yes | |||
ST_Disjoint() |
Yes | Yes | Yes | Yes | |||
ST_Distance() |
Yes | Yes | Yes | Yes | |||
ST_Distance_Sphere() |
Yes | Yes | Yes | Yes | |||
ST_EndPoint() |
Yes | Yes | Yes | Yes | |||
ST_Envelope() |
Yes | Yes | Yes | Yes | |||
ST_Equals() |
Yes | Yes | Yes | Yes | |||
ST_ExteriorRing() |
Yes | Yes | Yes | Yes | |||
ST_FrechetDistance() |
8.0.23 | Yes | Yes | Yes | Yes | ||
ST_GeoHash() |
Yes | Yes | Yes | Yes | |||
ST_GeomCollFromText(), ST_GeometryCollectionFromText(), ST_GeomCollFromTxt()
|
Yes | Yes | Yes | Yes | |||
ST_GeomCollFromWKB(), ST_GeometryCollectionFromWKB()
|
Yes | Yes | Yes | Yes | |||
ST_GeometryN() |
Yes | Yes | Yes | Yes | |||
ST_GeometryType() |
Yes | Yes | Yes | Yes | |||
ST_GeomFromGeoJSON() |
Yes | Yes | Yes | Yes | |||
ST_GeomFromText(), ST_GeometryFromText()
|
Yes | Yes | Yes | Yes | |||
ST_GeomFromWKB(), ST_GeometryFromWKB()
|
Yes | Yes | Yes | Yes | |||
ST_HausdorffDistance() |
8.0.23 | Yes | Yes | Yes | Yes | ||
ST_InteriorRingN() |
Yes | Yes | Yes | Yes | |||
ST_Intersection() |
Yes | Yes | Yes | Yes | |||
ST_Intersects() |
Yes | Yes | Yes | Yes | |||
ST_IsClosed() |
Yes | Yes | Yes | Yes | |||
ST_IsEmpty() |
Yes | Yes | Yes | Yes | |||
ST_IsSimple() |
Yes | Yes | Yes | Yes | |||
ST_IsValid() |
Yes | Yes | Yes | Yes | |||
ST_LatFromGeoHash() |
Yes | Yes | Yes | Yes | |||
ST_Latitude() |
8.0.12 | Yes | Yes | Yes | Yes | ||
ST_Length() |
Yes | Yes | Yes | Yes | |||
ST_LineFromText(), ST_LineStringFromText()
|
Yes | Yes | Yes | Yes | |||
ST_LineFromWKB(), ST_LineStringFromWKB()
|
Yes | Yes | Yes | Yes | |||
ST_LineInterpolatePoint() |
8.0.24 | Yes | Yes | Yes | Yes | ||
ST_LineInterpolatePoints() |
8.0.24 | Yes | Yes | Yes | Yes | ||
ST_LongFromGeoHash() |
Yes | Yes | Yes | Yes | |||
ST_Longitude() |
8.0.12 | Yes | Yes | Yes | Yes | ||
ST_MakeEnvelope() |
Yes | Yes | Yes | Yes | |||
ST_MLineFromText(), ST_MultiLineStringFromText()
|
Yes | Yes | Yes | Yes | |||
ST_MLineFromWKB(), ST_MultiLineStringFromWKB()
|
Yes | Yes | Yes | Yes | |||
ST_MPointFromText(), ST_MultiPointFromText()
|
Yes | Yes | Yes | Yes | |||
ST_MPointFromWKB(), ST_MultiPointFromWKB()
|
Yes | Yes | Yes | Yes | |||
ST_MPolyFromText(), ST_MultiPolygonFromText()
|
Yes | Yes | Yes | Yes | |||
ST_MPolyFromWKB(), ST_MultiPolygonFromWKB()
|
Yes | Yes | Yes | Yes | |||
ST_NumGeometries() |
Yes | Yes | Yes | Yes | |||
ST_NumInteriorRing(), ST_NumInteriorRings()
|
Yes | Yes | Yes | Yes | |||
ST_NumPoints() |
Yes | Yes | Yes | Yes | |||
ST_Overlaps() |
Yes | Yes | Yes | Yes | |||
ST_PointAtDistance() |
8.0.24 | Yes | Yes | Yes | Yes | ||
ST_PointFromGeoHash() |
Yes | Yes | Yes | Yes | |||
ST_PointFromText() |
Yes | Yes | Yes | Yes | |||
ST_PointFromWKB() |
Yes | Yes | Yes | Yes | |||
ST_PointN() |
Yes | Yes | Yes | Yes | |||
ST_PolyFromText(), ST_PolygonFromText()
|
Yes | Yes | Yes | Yes | |||
ST_PolyFromWKB(), ST_PolygonFromWKB()
|
Yes | Yes | Yes | Yes | |||
ST_Simplify() |
Yes | Yes | Yes | Yes | |||
ST_SRID() |
Yes | Yes | Yes | Yes | |||
ST_StartPoint() |
Yes | Yes | Yes | Yes | |||
ST_SwapXY() |
8.0.1 | Yes | Yes | Yes | Yes | ||
ST_SymDifference() |
Yes | Yes | Yes | Yes | |||
ST_Touches() |
Yes | Yes | Yes | Yes | |||
ST_Transform() |
8.0.13 | Yes | Yes | Yes | Yes | ||
ST_Union() |
Yes | Yes | Yes | Yes | |||
ST_Validate() |
Yes | Yes | Yes | Yes | |||
ST_Within() |
Yes | Yes | Yes | Yes | |||
ST_X() |
Yes | Yes | Yes | Yes | |||
ST_Y() |
Yes | Yes | Yes | 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 | |||
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 | |||
STRING_TO_VECTOR() |
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 | |||
TIMESTAMP() |
Yes | Yes | Yes | Yes | |||
TIMESTAMPADD() |
Yes | Yes | Yes | Yes | |||
TIMESTAMPDIFF() |
Yes | Yes | Yes | Yes | |||
TO_BASE64() |
Yes | Yes | Yes | Yes | |||
TO_DAYS() |
Yes | Yes | Yes | Yes | |||
TO_SECONDS() |
Yes | Yes | Yes | Yes | |||
TRIM() |
Yes | Yes | Yes | Yes | |||
TRUNCATE() |
Yes | Yes | Yes | Yes | |||
UCASE() |
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 | Yes | Yes | Yes | |||
VALIDATE_PASSWORD_STRENGTH() |
Yes | 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 | |||
VECTOR_DIM() |
Yes | Yes | |||||
VECTOR_TO_STRING() |
Yes | Yes | |||||
VERSION() |
Yes | Yes | Yes | Yes | |||
WAIT_FOR_EXECUTED_GTID_SET() |
Yes | Yes | Yes | Yes | |||
WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS() |
8.0.18 | Yes | |||||
WEEK() |
Yes | Yes | Yes | Yes | |||
WEEKDAY() |
Yes | Yes | Yes | Yes | |||
WEEKOFYEAR() |
Yes | Yes | Yes | Yes | |||
WEIGHT_STRING() |
Yes | Yes | Yes | Yes | |||
XOR |
Yes | Yes | Yes | Yes | |||
YEAR() |
Yes | Yes | Yes | Yes | |||
YEARWEEK() |
Yes | Yes | Yes | Yes | |||
| |
Yes | Yes | Yes | Yes | |||
~ |
Yes | Yes | Yes | Yes |