MariaDB Control Functions

This page organizes commonly used flow control and logic judgment functions in MariaDB.

  1. BENCHMARK()

    In MariaDB, BENCHMARK() is a built-in function that repeats a given expression a specified number of times.

  2. CAST()

    In MariaDB, BENCHMARK() is a built-in function that converts a given value to the specified type and returns it.

  3. COALESCE()

    In MariaDB, COALESCE() is a built-in function that returns the first non-NULL value in the argument list.

  4. CONVERT()

    In MariaDB, it CONVERT() is a built-in function that converts any type of parameter value to the specified type or character set.

  5. DEFAULT()

    In MariaDB, DEFAULT() is a built-in function that returns the default value of a given table column.

  6. GREATEST()

    In MariaDB, GREATEST() is a built-in function that returns the maximum value from a given list of arguments.

  7. IFNULL()

    In MariaDB, IFNULL() is a built-in function that returns the second parameter if the first parameter is NULL, otherwise returns the first parameter.

  8. ISNULL()

    In MariaDB, ISNULL() is a built-in function that returns 1 if the gaven parameter is NULL, otherwise returns 0.

  9. LEAST()

    In MariaDB, LEAST() is a built-in function that returns the minimum value from a given list of arguments.

  10. NULLIF()

    In MariaDB, NULLIF() is a built-in function that returns NULL if the two given arguments are equal, otherwise returns the first argument.

  11. NVL()

    In MariaDB, NVL() is a built-in function that returns the first parameter if the first parameter is not NULL, otherwise returns the second parameter.

  12. SLEEP()

    In MariaDB, SLEEP() is a built-in function that pauses (sleeps) the current query for a specified number of seconds.