Dynamic Columns Functions

Manage schema-less data within relational tables. These functions, such as COLUMN_CREATE and COLUMN_GET, allow you to store and retrieve variable sets of columns in a single BLOB field.

COLUMN_ADD

Update dynamic columns. This function adds or updates values within a dynamic column blob, returning the new blob content.

COLUMN_CHECK

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

COLUMN_CREATE

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

COLUMN_DELETE

Remove dynamic columns. This function deletes specified columns from a dynamic column blob and returns the updated blob.

COLUMN_EXISTS

Check for a dynamic column. This function returns 1 if a specified column exists within a dynamic column blob, and 0 otherwise.

COLUMN_GET

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

COLUMN_JSON

Convert dynamic columns to JSON. This function returns a JSON string representation of the data stored in a dynamic column blob.

COLUMN_LIST

List dynamic column names. This function returns a comma-separated list of all column names contained within a dynamic column blob.

_{This page is licensed: CC BY-SA / Gnu FDL}