Articles

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

How the DATE_ADD() function works in Mariadb?

The DATE_ADD() function is a built-in function in Mariadb that adds a specified time interval to a date or datetime value and returns the result as a new date or datetime value.

How the GeometryFromText() function works in Mariadb?

The GeometryFromText() function is a spatial function that creates a geometry object from a well-known text (WKT) representation.

How the InteriorRingN() function works in Mariadb?

The InteriorRingN() function is a spatial function that returns the N-th interior ring of a polygon.

How the RELEASE_LOCK() function works in Mariadb?

The RELEASE_LOCK() function in MariaDB is used to release a user-level lock that was acquired with the GET_LOCK() function.

How the DATABASE() function works in Mariadb?

The DATABASE() function is a built-in function in Mariadb that returns the name of the current database. This function is often used to get the context of the current session or query.

How the GeometryCollectionFromWKB() function works in Mariadb?

The GeometryCollectionFromWKB() function is a spatial function that creates a geometry collection from a well-known binary (WKB) representation.

How the INSTR() function works in Mariadb?

The INSTR() function is a string function that returns the position of the first occurrence of a substring in a string.

How the CURTIME() function works in Mariadb?

The CURTIME() function is a built-in function in Mariadb that returns the current time as a time value. This function is often used to get the current time of the server or the session.

How the GeometryCollectionFromText() function works in Mariadb?

The GeometryCollectionFromText() function is a spatial function that creates a geometry collection from a well-known text (WKT) representation.

How the INSERT() function works in Mariadb?

The INSERT() function is a string function that replaces a substring of a string with another string.