Articles

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

How the SLEEP() function works in Mariadb?

The SLEEP() function in MariaDB is used to introduce a delay or pause in the execution of a SQL statement or stored procedure for a specified number of seconds.

How the JSON_COMPACT() function works in Mariadb?

The JSON_COMPACT() function is a JSON function that removes whitespace and other unnecessary characters from a JSON document.

How the LineStringFromText() function works in Mariadb?

The LineStringFromText() function is a spatial function that converts a text representation of a line to a geometry value.

How the MINUTE() function works in Mariadb?

The MINUTE() function is a useful tool for extracting the minute part of a time or datetime value.

How the SIN() function works in Mariadb?

The SIN() function in MariaDB is used to calculate the trigonometric sine of a given angle expressed in radians.

How the JSON_ARRAY() function works in Mariadb?

The JSON_ARRAY() function is a JSON function that creates a JSON array from a list of values.

How the LINESTRING() function works in Mariadb?

The LINESTRING() function is a spatial function that creates a line geometry from a list of point coordinates.

How the MIN() function works in Mariadb?

The MIN() function is a useful tool for finding the minimum value of a set of values.

How the SIGN() function works in Mariadb?

The SIGN() function in MariaDB is a simple but useful function that returns the sign of a given numeric value.

How the JSON_ARRAY_INTERSECT() function works in Mariadb?

The MariaDB JSON_ARRAY_INTERSECT() function is used to find the intersection of two JSON arrays, returning an array containing elements that appear in both input arrays.