Posts

How the DATE_FORMAT() function works in Mariadb?

The DATE_FORMAT() function is a built-in function in Mariadb that formats a date or datetime value according to a specified format string and returns the result as a new string value.

How the GeometryFromWKB() function works in Mariadb?

The GeometryFromWKB() function is a spatial function that creates a geometry object from a well-known binary (WKB) representation.

How the INTERSECTS() function works in Mariadb?

The INTERSECTS() function is a spatial function that tests whether two geometries intersect or not.

How the REPEAT() function works in Mariadb?

The REPEAT() function in MariaDB is a string function that returns a string repeated a certain number of times.

How the DATE_ADD() function works in Mariadb?

The DATE_ADD() function is a built-in function in Mariadb that adds a specified time interval to a date or datetime value and returns the result as a new date or datetime value.

How the GeometryFromText() function works in Mariadb?

The GeometryFromText() function is a spatial function that creates a geometry object from a well-known text (WKT) representation.

How the InteriorRingN() function works in Mariadb?

The InteriorRingN() function is a spatial function that returns the N-th interior ring of a polygon.

How the RELEASE_LOCK() function works in Mariadb?

The RELEASE_LOCK() function in MariaDB is used to release a user-level lock that was acquired with the GET_LOCK() function.

How the DATABASE() function works in Mariadb?

The DATABASE() function is a built-in function in Mariadb that returns the name of the current database. This function is often used to get the context of the current session or query.

How the GeometryCollectionFromWKB() function works in Mariadb?

The GeometryCollectionFromWKB() function is a spatial function that creates a geometry collection from a well-known binary (WKB) representation.

How the INSTR() function works in Mariadb?

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

How the CURTIME() function works in Mariadb?

The CURTIME() function is a built-in function in Mariadb that returns the current time as a time value. This function is often used to get the current time of the server or the session.

How the GeometryCollectionFromText() function works in Mariadb?

The GeometryCollectionFromText() function is a spatial function that creates a geometry collection from a well-known text (WKT) representation.

How the INSERT() function works in Mariadb?

The INSERT() function is a string function that replaces a substring of a string with another string.

How the CURRENT_USER() function works in Mariadb?

The CURRENT_USER() function is a built-in function in Mariadb that returns the user name and host name of the current user account.

How the GEOMETRYCOLLECTION() function works in Mariadb?

The MariaDB GEOMETRYCOLLECTION() function is used to create a geometry collection object from a set of individual geometry objects.

How the INET6_NTOA() function works in Mariadb?

The INET6_NTOA() function is a string function that converts a binary value to an IPv6 address in standard notation.

How the CURRENT_TIMESTAMP() function works in Mariadb?

The CURRENT_TIMESTAMP() function is a built-in function in Mariadb that returns the current date and time as a datetime value.

How the GeomCollFromWKB() function works in Mariadb?

The GeomCollFromWKB() function is a spatial function that creates a geometry collection from a well-known binary (WKB) representation.

How the INET6_ATON() function works in Mariadb?

The INET6_ATON() function is a string function that converts an IPv6 address in standard or compressed notation to a binary value.

How the CURRENT_TIME() function works in Mariadb?

The CURRENT_TIME() function is a date and time function that returns the current time as a value in HH:MM:SS format.

How the GeomCollFromText() function works in Mariadb?

The GeomCollFromText() function is a spatial function that creates a geometry collection from a well-known text (WKT) representation.

How the INET_NTOA() function works in Mariadb?

The INET_NTOA() function is a string function that converts a numeric value to an IPv4 address in dotted-quad notation.

How the CURRENT_ROLE() function works in Mariadb?

The MariaDB CURRENT_ROLE() function is used to return the active roles for the current user session.

How the FROM_UNIXTIME() function works in Mariadb?

The FROM_UNIXTIME() function is a date and time function that converts a Unix timestamp to a datetime value.

How the INET_ATON() function works in Mariadb?

The INET_ATON() function is a string function that converts an IPv4 address in dotted-quad notation to a numeric value.

How the CURRENT_DATE() function works in Mariadb?

The MariaDB CURRENT_DATE() function is used to retrieve the current date as a value in ‘YYYY-MM-DD’ or ‘YYYYMMDD’ format, depending on whether the function is used in a string or numeric context.

How the FROM_DAYS() function works in Mariadb?

The MariaDB FROM_DAYS() function is used to convert a day count (the number of days since the year 0) to a DATE value.

How the IN() operator works in Mariadb?

The IN operator is a logical operator that tests whether a value or an expression matches any value in a list of values.

How the CURDATE() function works in Mariadb?

The CURDATE() function is a date and time function that returns the current date as a value in YYYY-MM-DD format.

How the FROM_BASE64() function works in Mariadb?

The MariaDB FROM_BASE64() function is used to decode a string that is encoded using the base64 encoding scheme.

How the IFNULL() function works in Mariadb?

The IFNULL() function is a conditional function that returns the first argument if it is not NULL, otherwise it returns the second argument.

How the CUME_DIST() function works in Mariadb?

The MariaDB CUME_DIST() function is used to calculate the cumulative distribution of a value within a group of values.

How the FOUND_ROWS() function works in Mariadb?

The MariaDB FOUND_ROWS() function is used to retrieve the number of rows that would be returned by a SELECT statement, regardless of any LIMIT clause that may have been applied.

How the IF() function works in Mariadb?

The IF() function is a conditional function that returns a value based on a given condition.

How the CROSSES() function works in Mariadb?

The CROSSES() function is a spatial function that returns 1 if two geometries cross each other, 0 if they do not, or NULL if either geometry is NULL or invalid.

How the FORMAT() function works in Mariadb?

The FORMAT() function is a string function that formats and returns the given number as a string, adding separators to appropriate positions and rounding the results to the given decimal position.

How the HOUR() function works in Mariadb?

The HOUR() function is a date and time function that returns the hour part of a time or datetime value.

How the CRC32C() function works in Mariadb?

The CRC32C() function is a string function that returns the cyclic redundancy check (CRC) value of a given string, using the Castagnoli polynomial.

How the FORMAT_PICO_TIME() function works in Mariadb?

The FORMAT_PICO_TIME() function is a string function that returns a human-readable time value and unit indicator for a given time in picoseconds.

How the HEX() function works in Mariadb?

The HEX() function is a string function that returns the hexadecimal representation of a numeric or string value.

How the CRC32() function works in Mariadb?

The CRC32() function is a string function that returns the cyclic redundancy check (CRC) value of a given string. The function returns an unsigned 32-bit integer value that represents the CRC-32 checksum of the string.

How the FLOOR() function works in Mariadb?

The FLOOR() function is a mathematical function that returns the largest integer value that is less than or equal to a given number.

How the GROUP_CONCAT() function works in Mariadb?

The GROUP_CONCAT() function is an aggregate function that returns a concatenated string of the non-null values in a group.

How the COUNT() function works in Mariadb?

The MariaDB COUNT() function is used to count the number of rows that match a specified condition or retrieve the number of non-NULL values in a particular column.

How the FIND_IN_SET() function works in Mariadb?

The FIND_IN_SET() function is a string function that returns the position of a string in a comma-separated list of strings.

How the GREATEST() function works in Mariadb?

The GREATEST() function is a comparison function that returns the greatest value among a list of values.

How the COUNT(DISTINCT) function works in Mariadb?

The MariaDB COUNT(DISTINCT) function is used to return the count of distinct non-NULL values in a set.

How the FIELD() function works in Mariadb?

The MariaDB FIELD() function is used to return the index position of a string within a list of strings.

How the GLENGTH() function works in Mariadb?

The MariaDB GLENGTH() function is used to return the length of a lstring in units of its spatial reference.