Articles

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

How the MAKE_SET() function works in Mariadb?

The MAKE_SET() function is a string function that returns a set of strings that are selected from a list of strings based on a given bit mask.

How the MULTIPOINT() function works in Mariadb?

The MULTIPOINT() function is a spatial function that creates a geometry collection of points from a set of coordinates or point geometries.

How the SUBDATE() function works in Mariadb?

The SUBDATE() function in MariaDB is used to subtract a specified time interval from a given date or datetime value.

How the JSON_MERGE_PATCH() function works in Mariadb?

The JSON_MERGE_PATCH() function is a JSON function that merges two or more JSON documents and returns the result as a JSON document.

How the LTRIM() function works in Mariadb?

The LTRIM() function is a string function that returns a string that is left-trimmed of any leading spaces.

How the MultiLineStringFromWKB() function works in Mariadb?

The MultiLineStringFromWKB() function is a spatial function that creates a MULTILINESTRING object from a Well-Known Binary (WKB) representation.

How the STRCMP() function works in Mariadb?

he STRCMP() function in MariaDB is used to compare two strings lexically (based on their character values).

How the JSON_LOOSE() function works in Mariadb?

In this article, we will introduce the JSON_LOOSE() function in Mariadb, which is a built-in function that adds spaces to a JSON document to make it more readable.

How the LPAD() function works in Mariadb?

The LPAD() function is a string function that returns a string that is left-padded with a specified character to a certain length.

How the MultiLineStringFromText() function works in Mariadb?

The MultiLineStringFromText() function is a spatial function that creates a MULTILINESTRING object from a text representation.