Posts

How the UPPER() function works in Mariadb?

The UPPER() function in MariaDB is used to convert a string to uppercase.

How the PI() function works in Mariadb?

The PI() function is a built-in function in Mariadb that returns the value of the mathematical constant pi, which is approximately 3.14159.

How the RADIANS() function works in Mariadb?

The RADIANS() function is a mathematical function in Mariadb that returns the value of an angle in radians.

How the UPDATEXML() function works in Mariadb?

The UPDATEXML() function in MariaDB is used to modify a portion of an XML-formatted string by replacing, inserting, or deleting nodes or values within the XML structure.

How the PERIOD_DIFF() function works in Mariadb?

The PERIOD_DIFF() function is a built-in function in Mariadb that returns the number of months between two periods.

How the QUOTE() function works in Mariadb?

The QUOTE() function is a string function in Mariadb that returns a single-quoted string that is safe to use in a SQL statement.

How the UNIX_TIMESTAMP() function works in Mariadb?

The UNIX_TIMESTAMP() function in MariaDB is used to retrieve the current Unix timestamp or convert a date and time value into a Unix timestamp.

How the PERIOD_ADD() function works in Mariadb?

The PERIOD_ADD() function is a built-in function in Mariadb that returns a period that is a number of months away from a given period.

How the QUARTER() function works in Mariadb?

The QUARTER() function is a date and time function in Mariadb that returns the quarter of the year for a given date.

How the UNHEX() function works in Mariadb?

The UNHEX() function in MariaDB is used to convert a hexadecimal string representation of a value into a string or binary value.

How the PERCENTILE_DISC() function works in Mariadb?

he PERCENTILE_DISC() function is a built-in function in Mariadb that returns the value of a given percentile within a group of values.

How the POWER() function works in Mariadb?

The POWER() function is a mathematical function in Mariadb that returns the value of a number raised to the power of another number.

How the UNCOMPRESSED_LENGTH() function works in Mariadb?

The UNCOMPRESSED_LENGTH() function in MariaDB is used to determine the length of a compressed string before it is uncompressed.

How the PERCENTILE_CONT() function works in Mariadb?

The PERCENTILE_CONT() function is a built-in function in Mariadb that returns the value of a given percentile within a group of values.

How the POW() function works in Mariadb?

The POW() function is a mathematical function in Mariadb that returns the value of a number raised to the power of another number.

How the UNCOMPRESS() function works in Mariadb?

The UNCOMPRESS() function in MariaDB is used to uncompress a string that has been compressed using the COMPRESS() function.

How the PERCENT_RANK() function works in Mariadb?

The PERCENT_RANK() function is a built-in function in Mariadb that returns the relative rank of a row within a group of rows.

How the POSITION() function works in Mariadb?

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

How the UCASE() function works in Mariadb?

The UCASE() function in MariaDB is used to convert a string to uppercase.

How the PASSWORD() function works in Mariadb?

The PASSWORD() function is a built-in function in Mariadb that returns the hashed password of a string value using the new password format.

How the PolygonFromWKB() function works in Mariadb?

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

How the TRUNCATE() function works in Mariadb?

The TRUNCATE() function in MariaDB is used to truncate a number to a specified number of decimal places.

How the OVERLAPS() function works in Mariadb?

The OVERLAPS() function is a spatial function in Mariadb that returns 1 or 0 to indicate whether two geometries spatially overlap.

How the PolygonFromText() function works in Mariadb?

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

How the TRIM() function works in Mariadb?

The TRIM() function in MariaDB is used to remove leading and trailing spaces or specified characters from a string.

How the ORD() function works in Mariadb?

The ORD() function is a built-in function in Mariadb that returns the numeric ASCII code of the first character of a string value.

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 OLD_PASSWORD() function works in Mariadb?

The OLD_PASSWORD() function is a built-in function in Mariadb that returns the hashed password of a string value using the pre-4.1 hashing algorithm.

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.

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.

How the TO_CHAR() function works in Mariadb?

The TO_CHAR() function in MariaDB is used to convert a date, datetime, time or timestamp value into a string representation.

How the JSON_UNQUOTE() function works in Mariadb?

The JSON_UNQUOTE() function is a simple but useful function for removing the double quotes from a JSON value.

How the NumInteriorRings() function works in Mariadb?

The NumInteriorRings() function is a spatial function in Mariadb that returns the number of interior rings in a polygon, or 0 if the argument is not a polygon.

How the TO_BASE64() function works in Mariadb?

The TO_BASE64() function in MariaDB is used to convert a string or binary value into its Base64 encoded representation.

How the JSON_TYPE() function works in Mariadb?

The JSON_TYPE() function is a simple but useful function for inspecting the type of a JSON value.

How the NumGeometries() function works in Mariadb?

The NumGeometries() function is a spatial function in Mariadb that returns the number of geometries in a geometry collection, or 1 if the argument is not a geometry collection.

How the TIMESTAMPDIFF() function works in Mariadb?

The TIMESTAMPDIFF() function in MariaDB is used to calculate the difference between two date or datetime expressions.

How the JSON_TABLE() function works in Mariadb?

The JSON_TABLE() function is a powerful and versatile tool for extracting data from JSON documents and converting them into tabular format.

How the NULLIF() function works in Mariadb?

The NULLIF() function is a useful function in Mariadb that returns NULL if two expressions are equal, or the first expression if they are not.

How the TIMESTAMPADD() function works in Mariadb?

The TIMESTAMPADD() function in MariaDB is used to add an interval to a date or datetime expression.

How the JSON_SET() function works in Mariadb?

The JSON_SET() function is a JSON function that inserts or updates data in a JSON document and returns the result as a JSON document.

How the NTILE() function works in Mariadb?

The NTILE() function is a window function that divides a result set into a specified number of groups of approximately equal size.