Articles

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

How the POLYGON() function works in Mariadb?

The POLYGON() function is a spatial function in Mariadb that creates a Polygon object from a list of coordinates.

How the TOUCHES() function works in Mariadb?

The TOUCHES() function in MariaDB is a spatial function used to test whether two geometries touch each other.

How the PolyFromWKB() function works in Mariadb?

The PolyFromWKB() function is a spatial function in Mariadb that creates a Polygon object from a well-known binary (WKB) representation.

MariaDB OLD_PASSWORD() Function

Learn what MariaDB OLD_PASSWORD() returns, why it exists for pre-4.1 compatibility, and why it must not be used for new accounts or application passwords.

How the OCTET_LENGTH() function works in Mariadb?

The OCTET_LENGTH() function is a built-in function in Mariadb that returns the number of bytes in a string value.

How the PolyFromText() function works in Mariadb?

The PolyFromText() function is a spatial function in Mariadb that creates a Polygon object from a well-known text (WKT) representation.

How the TO_SECONDS() function works in Mariadb?

The TO_SECONDS() function in MariaDB is used to convert a time or datetime value into the corresponding number of seconds.

How the JSON_VALUE() function works in Mariadb?

The JSON_VALUE() function is a useful tool for extracting scalar values from JSON documents in Mariadb.

How the OCT() function works in Mariadb?

The OCT() function is a built-in function in Mariadb that returns the octal representation of a decimal or string value.

How the TO_DAYS() function works in Mariadb?

The TO_DAYS() function in MariaDB is used to convert a date or datetime value into the corresponding day number.