Articles

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

How the STR_TO_DATE() function works in Mariadb?

The STR_TO_DATE() function in MariaDB is used to parse a string representation of a date and time and convert it into a DATE or DATETIME value.

How the JSON_LENGTH() function works in Mariadb?

The JSON_LENGTH() function is a JSON function that returns the length of a JSON document.

How the LOWER() function works in Mariadb?

The LOWER() function is a string function that returns a string with all the characters converted to lowercase.

How the MULTILINESTRING() function works in Mariadb?

The MULTILINESTRING() function is a spatial function that creates a MULTILINESTRING object from a list of line strings.

How the STDDEV() function works in Mariadb?

The STDDEV() function, short for standard deviation, is a statistical measure used in MariaDB to quantify the amount of variation or dispersion in a set of values.

How the JSON_KEYS() function works in Mariadb?

The JSON_KEYS() function is a JSON function that returns the keys of a JSON object.

How the LOG10() function works in Mariadb?

The LOG10() function is a mathematical function that returns the logarithm of a number to the base 10.

How the MPolyFromWKB() function works in Mariadb?

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

How the STDDEV_SAMP() function works in Mariadb?

The STDDEV_SAMP() function in MariaDB is a statistical function that calculates the sample standard deviation of a set of values.

How the JSON_INSERT() function works in Mariadb?

The JSON_INSERT() function is a JSON function that inserts a value or values into a JSON document at a given path or paths.