> 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/server/reference/sql-functions/special-functions/dynamic-columns-functions.md).

# Dynamic Columns Functions

{% columns %}
{% column %}
{% content-ref url="/pages/aw8yP0dmEg3l3ejjvZ1h" %}
[COLUMN\_ADD](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_add.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Update dynamic columns. This function adds or updates values within a dynamic column blob, returning the new blob content.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/RYcZRUpyplW4hb3r8D55" %}
[COLUMN\_CHECK](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_check.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Verify dynamic column integrity. This function checks if a blob containing dynamic columns is valid and returns 1 if it is, 0 otherwise.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/0QUiWaMwxPvfhDNOiCfQ" %}
[COLUMN\_CREATE](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_create.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Create a dynamic column blob. This function generates a binary string containing specified column names and values for storage in a BLOB.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/N2KZkzpswgBgbNCUOrao" %}
[COLUMN\_DELETE](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_delete.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Remove dynamic columns. This function deletes specified columns from a dynamic column blob and returns the updated blob.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Slr0htQPT1f8yYG6SWeK" %}
[COLUMN\_EXISTS](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_exists.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Check for a dynamic column. This function returns 1 if a specified column exists within a dynamic column blob, and 0 otherwise.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/buJKqH5bpJxvtMmFXqhK" %}
[COLUMN\_GET](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_get.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Retrieve a dynamic column value. This function extracts a specific column's value from a dynamic column blob, casting it to a specified type.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/NmeY0s3jY8uTsWZArUco" %}
[COLUMN\_JSON](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_json.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Convert dynamic columns to JSON. This function returns a JSON string representation of the data stored in a dynamic column blob.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/os7bTUJqPLcGInPEIYay" %}
[COLUMN\_LIST](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_list.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
List dynamic column names. This function returns a comma-separated list of all column names contained within a dynamic column blob.
{% endcolumn %}
{% endcolumns %}