MariaDB Information Function

This page organizes MariaDB’s built-in functions for obtaining commonly used information.

  1. CHARSET()

    In MariaDB, CHARSET() is a built-in function that returns the character set of a given string.

  2. COERCABILITY()

    In MariaDB, COERCIBILITY() is a built-in function that returns the collation-enforced value for a given string argument.

  3. COLLATION()

    In MariaDB, COLLATION() is a built-in function that returns the collation for a given string.

  4. CONNECTION_ID()

    In MariaDB, CONNECTION_ID() is a built-in function that returns the unique ID for the current connection.

  5. CURRENT_ROLE()

    In MariaDB, CURRENT_ROLE() is a built-in function that returns a string representing the roles currently active in the current session, with multiple roles separated by commas.

  6. CURRENT_USER()

    In MariaDB, CURRENT_USER() is a built-in function that returns the username and hostname of the MariaDB account that the MariaDB server uses to authenticate the current client.

  7. DATABASE()

    In MariaDB, DATABASE() is a built-in function that returns the current database name as a string.

  8. FOUND_ROWS()

    In MariaDB, FOUND_ROWS() is a built-in function that returns the total number of rows for the last query that needed to count rows.

  9. LAST_INSERT_ID()

    In MariaDB, LAST_INSERT_ID() is a built-in function that returns the value generated by the auto AUTO_INCREMENT column for the last insertion.

  10. ROW_COUNT()

    In MariaDB, ROW_COUNT() is a built-in function that returns the number of rows affected by the last update, insert or delete statement.

  11. ROWNUM()

    In MariaDB, ROWNUM() is a built-in function that returns the row number for each row in the current query.

  12. SCHEMA()

    In MariaDB, SCHEMA() is a built-in function that returns the current database name as a string.

  13. SESSION_USER()

    In MariaDB, SESSION_USER() is a built-in function that returns the username and hostname of the current MariaDB account.

  14. SYS_GUID()

    In MariaDB, SYS_GUID() is a built-in function that returns a 16-byte globally unique identifier (GUID).

  15. SYSTEM_USER()

    In MariaDB, SYSTEM_USER() is a built-in function that returns the username and hostname of the current MariaDB account.

  16. USER()

    In MariaDB, USER() is a built-in function that returns the username and hostname of the current MariaDB account.

  17. UUID_SHORT()

    In MariaDB, UUID_SHORT() is a built-in function that returns a short, conditionally unique Universal Identifier (UUID).

  18. UUID()

    In MariaDB, UUID() is a built-in function that returns a Universally Unique Identifier (UUID) generated according to RFC 4122.

  19. VERSION()

    In MariaDB, VERSION() is a built-in function that returns a UTF8 string representing the version of MariaDB server.