Posts

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.

How the CONCAT_WS() function works in Mariadb?

The CONCAT_WS() function is a string function that concatenates two or more strings with a specified separator.

How the ENCODE() function works in Mariadb?

The ENCODE() function is a string function that encrypts a string using a given key.

How the COMPRESS() function works in Mariadb?

The COMPRESS() function is a string function that compresses a string and returns the result as a binary string.

How the ELT() function works in Mariadb?

The MariaDB ELT() function is used to return the N-th element from a list of strings.

How the COLLATION() function works in Mariadb?

The COLLATION() function is a string function that returns the name of the collation of a given string. The collation of a string determines how the string is sorted and compared.

How the DIV operator works in Mariadb?

The DIV operator is a built-in operator in Mariadb that performs integer division, which means it divides the dividend by the divisor and returns the integer result of the division with any decimal places truncated from the value.