Posts

How the JSON_COMPACT() function works in Mariadb?

The JSON_COMPACT() function is a JSON function that removes whitespace and other unnecessary characters from a JSON document.

How the LineStringFromText() function works in Mariadb?

The LineStringFromText() function is a spatial function that converts a text representation of a line to a geometry value.

How the MINUTE() function works in Mariadb?

The MINUTE() function is a useful tool for extracting the minute part of a time or datetime value.

How the SIN() function works in Mariadb?

The SIN() function in MariaDB is used to calculate the trigonometric sine of a given angle expressed in radians.

How the JSON_ARRAY() function works in Mariadb?

The JSON_ARRAY() function is a JSON function that creates a JSON array from a list of values.

How the LINESTRING() function works in Mariadb?

The LINESTRING() function is a spatial function that creates a line geometry from a list of point coordinates.

How the MIN() function works in Mariadb?

The MIN() function is a useful tool for finding the minimum value of a set of values.

How the SIGN() function works in Mariadb?

The SIGN() function in MariaDB is a simple but useful function that returns the sign of a given numeric value.

How the JSON_ARRAY_INTERSECT() function works in Mariadb?

The MariaDB JSON_ARRAY_INTERSECT() function is used to find the intersection of two JSON arrays, returning an array containing elements that appear in both input arrays.

How the LineFromWKB() function works in Mariadb?

The LineFromWKB() function is a spatial function that converts a binary representation of a line to a geometry value.

How the MID() function works in Mariadb?

The MID() function is a useful tool for extracting a substring from a given string.

How the SHA2() function works in Mariadb?

The SHA2() function in MariaDB is a versatile function that allows you to compute various cryptographic hash values belonging to the SHA-2 family of hash functions.

How the JSON_ARRAY_INSERT() function works in Mariadb?

The JSON_ARRAY_INSERT() function is a JSON function that inserts values into an array within a JSON document.

How the LineFromText() function works in Mariadb?

The LineFromText() function is a spatial function that converts a text representation of a line to a geometry value.

How the MICROSECOND() function works in Mariadb?

The MICROSECOND() function is a useful tool for extracting the microsecond part of a time or datetime value.

How the SHA1() function works in Mariadb?

The SHA1() function in MariaDB is used to compute the SHA-1 160-bit cryptographic hash value of a given string.

How the JSON_ARRAY_APPEND() function works in Mariadb?

The JSON_ARRAY_APPEND() function is a JSON function that appends values to the end of an array within a JSON document.

How the LIKE operation works in Mariadb?

The LIKE operation is a logical operation that tests whether a string matches a specified pattern.

How the MEDIAN() function works in Mariadb?

The MEDIAN() function is a useful tool for calculating the median value of a set of numbers.

How the SHA() function works in Mariadb?

The SHA() function in MariaDB is used to calculate the Secure Hash Algorithm (SHA) hash value of a given string.

How the IsSimple() function works in Mariadb?

The MariaDB IsSimple() function is used to verify that a given geometry does not have any anomalous geometric points, such as self-intersections or complex loops.

How the LENGTH() function works in Mariadb?

The LENGTH() function is a string function that returns the length of a given string in bytes.

How the MD5() function works in Mariadb?

The MD5() function is a useful tool for generating a 32-digit hexadecimal hash value from a given string.

How the SETVAL() function works in Mariadb?

The SETVAL() function in MariaDB is used to set the sequence counter for a specified sequence object to a specific value.

How the IsRing() function works in Mariadb?

The MariaDB IsRing() function is used to assess whether a given LINESTRING is a ring.

How the LEFT() function works in Mariadb?

The LEFT() function is a string function that returns the leftmost part of a given string, up to a specified number of characters.

How the MBRWithin() function works in Mariadb?

The MBRWithin() function is a useful tool for performing spatial queries in Mariadb.

How the SESSION_USER() function works in Mariadb?

The SESSION_USER() function in MariaDB is used to retrieve the current user’s username and hostname associated with the current session.

How the ISNULL() function works in Mariadb?

The MariaDB ISNULL() function is used to determine if a specified expression is NULL.

How the LEAST() function works in Mariadb?

The LEAST() function is a numeric function that returns the smallest value among a list of values.

How the MBRTouches() function works in Mariadb?

The MBRTouches() function is a useful tool for performing spatial queries in Mariadb.

How the SECOND() function works in Mariadb?

The SECOND() function in MariaDB is used to extract the seconds part from a TIME or DATETIME value.

How the IsEmpty() function works in Mariadb?

The IsEmpty() function is a spatial function that returns 1 if the geometry argument is an empty geometry collection, or 0 otherwise.

How the LCASE() function works in Mariadb?

The LCASE() function is a string function that converts all the characters in a given string to lowercase.

How the MBROverlaps() function works in Mariadb?

The MBROverlaps() function is a useful tool for performing spatial queries in Mariadb.

How the SEC_TO_TIME() function works in Mariadb?

The SEC_TO_TIME() function in MariaDB is used to convert a value representing seconds into a TIME value.

How the IsClosed() function works in Mariadb?

The MariaDB IsClosed() function is used to determine if a given LINESTRING’s start and end points are the same.

How the LAST_VALUE() function works in Mariadb?

The LAST_VALUE() function is a window function that returns the last value of an expression within a partition or a result set.

How the MBRIntersects() function works in Mariadb?

The MBRIntersects() function is a useful tool for performing spatial queries in Mariadb.

How the SCHEMA() function works in Mariadb?

The SCHEMA() function in MariaDB is used to retrieve the name of the current database schema or database from which it is being called.

How the IS-NULL operator works in Mariadb?

The MariaDB IS NULL operator is used to check if a value in a column or expression is NULL.

How the LAST_INSERT_ID() function works in Mariadb?

The LAST_INSERT_ID() function is a information function that returns the value of the AUTO_INCREMENT column for the last row that was inserted or updated by the current session.

How the MBREqual() function works in Mariadb?

The MBREqual() function is a useful tool for performing spatial queries in Mariadb.

How the RTRIM() function works in Mariadb?

The RTRIM() function is a string function that removes all trailing spaces from a string.

How the IS NOT NULL operator works in Mariadb?

The MariaDB IS NOT NULL operator is used to check if a value in a column or expression is not NULL.

How the LAST_DAY() function works in Mariadb?

The LAST_DAY() function is a date and time function that returns the last day of the month for a given date.

How the MBRDisjoint() function works in Mariadb?

The MBRDisjoint() function is a useful tool for performing spatial queries in Mariadb.

How the RPAD() function works in Mariadb?

The RPAD() function in MariaDB is a string function that pads the right side of a string with a specified number of a specified character.

How the IS_USED_LOCK() function works in Mariadb?

In this article, we will introduce the IS_USED_LOCK() function in Mariadb, which is a locking function that checks whether a named user-level lock is in use or not.

How the MBRContains() function works in Mariadb?

The MBRContains() function is a useful tool for performing spatial queries in Mariadb.