Posts

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.

How the COT() function works in Mariadb?

The COT() function is a mathematical function that returns the cotangent of a given angle. The function returns a decimal value that represents the cotangent of the angle in radians.

How the EXTRACTVALUE() function works in Mariadb?

The EXTRACTVALUE() function is an XML function that extracts a value from an XML document using an XPath expression.

How the COS() function works in Mariadb?

The COS() function is a mathematical function that returns the cosine of a given angle. The function returns a decimal value between -1 and 1, representing the cosine of the angle in radians.

How the EXTRACT() function works in Mariadb?

The EXTRACT() function is a date and time function that extracts a specific part of a date or time value.

How the CONVEXHULL() function works in Mariadb?

The CONVEXHULL() function is a spatial function that returns the convex hull of a geometry. The convex hull of a geometry is the smallest convex polygon that contains the geometry.

How the ExteriorRing() function works in Mariadb?

The ExteriorRing() function is a spatial function that returns the exterior ring of a polygon.

How the CONVERT() function works in Mariadb?

The MariaDB CONVERT() function is used to convert a value from one data type to another.

How the EXPORT_SET() function works in Mariadb?

The EXPORT_SET() function is a string function that returns a string where each bit in the given bits argument is represented by the on or off string values.

How the CONVERT_TZ() function works in Mariadb?

The MariaDB CONVERT_TZ() function is used to convert a datetime value from one time zone to another.

How the EXP() function works in Mariadb?

The EXP() function is a numeric function that returns the value of e (the base of natural logarithms) raised to the power of the argument.

How the CONV() function works in Mariadb?

The CONV() function is a mathematical function that converts a number from one base to another base. The function returns a string that represents the converted number in the new base.

How the EQUALS() function works in Mariadb?

The EQUALS() function is a spatial function that compares two geometries and returns 1 if they are equal, 0 if they are not equal, or NULL if either geometry is NULL.

How the CONTAINS() function works in Mariadb?

The CONTAINS() function is a spatial function that tests whether a geometry contains another geometry.

How the ENVELOPE() function works in Mariadb?

The ENVELOPE() function is a geometric function that returns the minimum bounding rectangle (MBR) of a geometry.

How the CONNECTION_ID() function works in Mariadb?

The CONNECTION_ID() function is an information function that returns the connection ID of the current session. The connection ID is a unique identifier that is assigned to each client that connects to the server.

How the ENDPOINT() function works in Mariadb?

The ENDPOINT() function is a geometric function that returns the last point of a LineString geometry.

How the CONCAT() function works in Mariadb?

The CONCAT() function is a string function that concatenates two or more strings into one string. The function returns a string that is the result of joining the arguments in the order they appear.

How the ENCRYPT() function works in Mariadb?

The ENCRYPT() function is a string function that encrypts a string using the Unix crypt() system call and returns the encrypted value of the string.