Articles

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

MariaDB MPointFromText(): WKT and SRID Examples

Build a MariaDB MULTIPOINT from WKT with MPointFromText(), inspect its SRID, and understand why assigning an SRID does not transform coordinates.

How the JSON_EQUALS() function works in Mariadb?

The JSON_EQUALS() function is a JSON function that compares two JSON documents for equality.

How the LOCALTIMESTAMP() function works in Mariadb?

The LOCALTIMESTAMP() function is a date and time function that returns the current date and time as a TIMESTAMP value in the local time zone of the server.

How the MONTHNAME() function works in Mariadb?

The MONTHNAME() function is a date and time function that returns the name of the month for a given date.

How the SQRT() function works in Mariadb?

The SQRT() function in MariaDB is a mathematical function that calculates the square root of a given number.

How the JSON_DETAILED() function works in Mariadb?

The JSON_DETAILED() function is a JSON function that adds whitespace and other formatting characters to a JSON document.

How the LOCALTIME() function works in Mariadb?

The LOCALTIME() function is a date and time function that returns the current date and time in the local time zone of the server.

How the MONTH() function works in Mariadb?

The MONTH() function is a date and time function that returns the month number for a given date.

How the SPACE() function works in Mariadb?

The SPACE() function in MariaDB is a simple string function that returns a string consisting of a specified number of space characters.

How the JSON_DEPTH() function works in Mariadb?

The JSON_DEPTH() function is a JSON function that returns the maximum depth of a JSON document.