Articles

For side-by-side syntax and behavior across database engines, browse the cross-database SQL comparison guides.

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.

MariaDB GROUP_CONCAT() Function: Syntax and Examples

Learn how MariaDB GROUP_CONCAT() combines grouped values, removes duplicates, orders results, sets separators, and limits output.