Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

How the JSON_QUERY() function works in Mariadb?

The JSON_QUERY() function is a built-in function in Mariadb that allows you to extract a JSON document from another JSON document at a given path.

How the NEXTVAL() function works in Mariadb?

The NEXTVAL() function is a sequence function that returns the next value of a sequence.

MariaDB SYSTEM_USER(): Return Value and Examples

Learn what MariaDB SYSTEM_USER() returns, how it compares with USER() and CURRENT_USER(), and how to inspect client and privilege identities.

How the JSON_PRETTY() function works in Mariadb?

The JSON_PRETTY() function is a built-in function in Mariadb that allows you to add whitespace and indentation to a JSON document, making it more readable and human-friendly.

How the NATURAL_SORT_KEY() function works in Mariadb?

The NATURAL_SORT_KEY() function is a string function that returns a binary string that can be used to sort strings in a natural order.

How the SYSDATE() function works in Mariadb?

The SYSDATE() function in MariaDB is used to retrieve the current date and time from the server’s system clock.

How the JSON_OVERLAPS() function works in Mariadb?

The JSON_OVERLAPS() function is a built-in function in Mariadb that allows you to check whether two JSON documents have any elements in common.

How the NAME_CONST() function works in Mariadb?

The NAME_CONST() function is a utility function that assigns a name to a constant value.

How the SYS_GUID() function works in Mariadb?

The SYS_GUID() function in MariaDB is used to generate a globally unique identifier (GUID) based on a combination of various system values.

How the JSON_OBJECTAGG() function works in Mariadb?

The JSON_OBJECTAGG() function is a built-in function in Mariadb that allows you to create a JSON object from a set of key-value pairs.