> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/about/compatibility-and-differences/function-differences-between-mariadb-and-mysql/function-differences-between-mariadb-and-mysql-unmaintained-series/function-differences-between-mariadb-102-and-mysql-56.md).

# Function Differences Between MariaDB 10.2 and MySQL 5.6

The following is a list of all function differences between [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) and MySQL 5.6. It is based on functions available in the stable version [MariaDB 10.2.25](/docs/release-notes/community-server/old-releases/10.2/10.2.25.md).

## Present in MariaDB Only

### Dynamic Columns

* [COLUMN\_ADD](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_add.md)
* [COLUMN\_CHECK](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_check.md)
* [COLUMN\_CREATE](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_create.md)
* [COLUMN\_DELETE](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_delete.md)
* [COLUMN\_EXISTS](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_exists.md)
* [COLUMN\_GET](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_get.md)
* [COLUMN\_JSON](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_json.md)
* [COLUMN\_LIST](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_list.md)

### JSON

* [JSON\_ARRAY](/docs/server/reference/sql-functions/special-functions/json-functions/json_array.md)
* [JSON\_ARRAY\_APPEND](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_append.md)
* [JSON\_ARRAY\_INSERT](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_insert.md)
* [JSON\_COMPACT](/docs/server/reference/sql-functions/special-functions/json-functions/json_compact.md)
* [JSON\_CONTAINS](/docs/server/reference/sql-functions/special-functions/json-functions/json_contains.md)
* [JSON\_CONTAINS\_PATH](/docs/server/reference/sql-functions/special-functions/json-functions/json_contains_path.md)
* [JSON\_DEPTH](/docs/server/reference/sql-functions/special-functions/json-functions/json_depth.md)
* [JSON\_DETAILED](/docs/server/reference/sql-functions/special-functions/json-functions/json_detailed.md)
* [JSON\_EXISTS](/docs/server/reference/sql-functions/special-functions/json-functions/json_exists.md)
* [JSON\_EXTRACT](/docs/server/reference/sql-functions/special-functions/json-functions/json_extract.md)
* [JSON\_INSERT](/docs/server/reference/sql-functions/special-functions/json-functions/json_insert.md)
* [JSON\_KEYS](/docs/server/reference/sql-functions/special-functions/json-functions/json_keys.md)
* [JSON\_LENGTH](/docs/server/reference/sql-functions/special-functions/json-functions/json_length.md)
* [JSON\_LOOSE](/docs/server/reference/sql-functions/special-functions/json-functions/json_loose.md)
* [JSON\_MERGE](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge.md)
* [JSON\_MERGE\_PATCH](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge_patch.md)
* [JSON\_MERGE\_PRESERVE](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge_preserve.md)
* [JSON\_OBJECT](/docs/server/reference/sql-functions/special-functions/json-functions/json_object.md)
* [JSON\_QUERY](/docs/server/reference/sql-functions/special-functions/json-functions/json_query.md)
* [JSON\_QUOTE](/docs/server/reference/sql-functions/special-functions/json-functions/json_quote.md)
* [JSON\_REMOVE](/docs/server/reference/sql-functions/special-functions/json-functions/json_remove.md)
* [JSON\_REPLACE](/docs/server/reference/sql-functions/special-functions/json-functions/json_replace.md)
* [JSON\_SEARCH](/docs/server/reference/sql-functions/special-functions/json-functions/json_search.md)
* [JSON\_SET](/docs/server/reference/sql-functions/special-functions/json-functions/json_set.md)
* [JSON\_TYPE](/docs/server/reference/sql-functions/special-functions/json-functions/json_type.md)
* [JSON\_UNQUOTE](/docs/server/reference/sql-functions/special-functions/json-functions/json_unquote.md)
* [JSON\_VALID](/docs/server/reference/sql-functions/special-functions/json-functions/json_valid.md)
* [JSON\_VALUE](/docs/server/reference/sql-functions/special-functions/json-functions/json_value.md)

### Regular Expressions

* [REGEXP\_INSTR](/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp_instr.md)
* [REGEXP\_REPLACE](/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp_replace.md)
* [REGEXP\_SUBSTR](/docs/server/reference/sql-functions/string-functions/regular-expressions-functions/regexp_substr.md)

### Window Functions

* [CUME\_DIST](/docs/server/reference/sql-functions/special-functions/window-functions/cume_dist.md)
* [DENSE\_RANK](/docs/server/reference/sql-functions/special-functions/window-functions/dense_rank.md)
* [LAG](/docs/server/reference/sql-functions/special-functions/window-functions/lead.md)
* [LAST\_VALUE](/docs/server/reference/sql-functions/secondary-functions/information-functions/last_value.md)
* [LEAD](/docs/server/reference/sql-functions/special-functions/window-functions/lead.md)
* [NTH\_VALUE](/docs/server/reference/sql-functions/special-functions/window-functions/nth_value.md)
* [NTILE](/docs/server/reference/sql-functions/special-functions/window-functions/ntile.md)
* [PERCENT\_RANK](/docs/server/reference/sql-functions/special-functions/window-functions/percent_rank.md)
* [RANK](/docs/server/reference/sql-functions/special-functions/window-functions/rank.md)
* [ROW\_NUMBER](/docs/server/reference/sql-functions/special-functions/window-functions/row_number.md)

## Present in MySQL Only

### GTID

MariaDB and MySQL have differing [GTID](/docs/server/ha-and-performance/standard-replication/gtid.md) implementations.

* GTID\_SUBSET
* GTID\_SUBTRACT
* SQL\_THREAD\_WAIT\_AFTER\_GTIDS()
* WAIT\_UNTIL\_SQL\_THREAD\_AFTER\_GTIDS()

### Miscellaneous

* RANDOM\_BYTES
* VALIDATE\_PASSWORD\_STRENGTH

## See Also

* [Function Differences Between MariaDB 10.2 and MySQL 5.7](/docs/release-notes/community-server/about/compatibility-and-differences/function-differences-between-mariadb-and-mysql/function-differences-between-mariadb-and-mysql-unmaintained-series/function-differences-between-mariadb-102-and-mysql-57.md)
* [System Variable Differences Between MariaDB 10.2 and MySQL 5.6](/docs/release-notes/community-server/about/compatibility-and-differences/system-variable-differences-between-mariadb-and-mysql/system-variable-differences-between-mariadb-and-mysql-unmaintained-series/system-variable-differences-between-mariadb-10-2-and-mysql-5-6.md)
* [MariaDB versus MySQL - Compatibility](https://github.com/mariadb-corporation/docs-server/blob/test/release-notes/compatibility-and-differences/function-differences-between-mariadb-and-mysql/function-differences-between-mariadb-and-mysql-unmaintained-series/broken-reference/README.md)
* [MariaDB versus MySQL - Features](/docs/release-notes/community-server/about/compatibility-and-differences/mariadb-vs-mysql-features.md)

{% @marketo/form formid="4316" formId="4316" %}