Articles

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.

How the JSON_VALID() function works in Mariadb?

The JSON_VALID() function is a simple but useful function for validating whether a JSON value is well-formed and valid.

How the NumPoints() function works in Mariadb?

The NumPoints() function is a spatial function in Mariadb that returns the number of points in a linestring, or 0 if the argument is not a linestring.