Articles

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

How the CONVEXHULL() function works in Mariadb?

The CONVEXHULL() function is a spatial function that returns the convex hull of a geometry. The convex hull of a geometry is the smallest convex polygon that contains the geometry.

How the ExteriorRing() function works in Mariadb?

The ExteriorRing() function is a spatial function that returns the exterior ring of a polygon.

How the CONVERT() function works in Mariadb?

The MariaDB CONVERT() function is used to convert a value from one data type to another.

How the EXPORT_SET() function works in Mariadb?

The EXPORT_SET() function is a string function that returns a string where each bit in the given bits argument is represented by the on or off string values.

How the CONVERT_TZ() function works in Mariadb?

The MariaDB CONVERT_TZ() function is used to convert a datetime value from one time zone to another.

How the EXP() function works in Mariadb?

The EXP() function is a numeric function that returns the value of e (the base of natural logarithms) raised to the power of the argument.

How the CONV() function works in Mariadb?

The CONV() function is a mathematical function that converts a number from one base to another base. The function returns a string that represents the converted number in the new base.

How the EQUALS() function works in Mariadb?

The EQUALS() function is a spatial function that compares two geometries and returns 1 if they are equal, 0 if they are not equal, or NULL if either geometry is NULL.

How the CONTAINS() function works in Mariadb?

The CONTAINS() function is a spatial function that tests whether a geometry contains another geometry.

How the ENVELOPE() function works in Mariadb?

The ENVELOPE() function is a geometric function that returns the minimum bounding rectangle (MBR) of a geometry.