In MariaDB, you can use the LIMIT clause to reduce the number of rows returned by a query. The FOUND_ROWS() function can be used in such queries to return the number of rows that would have been returned, had the LIMIT clause not been included.

This can be handy, because it allows you to get this information without having to run the query again.

The FOUND_ROWS() function can also be used to return the number of rows that were actually returned by the limited statement, if that’s what you need.

Continue reading →

In MariaDB, the SCHEMA() function is a synonym for the DATABASE() function. It returns the default (current) database name.

The result is returned as a string in the utf8 character set.

Continue reading →

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

The result is returned as a string in the utf8 character set.

Continue reading →

In MariaDB, SYSTEM_USER() is a synonym for the USER() function. It returns the current MariaDB user name and host name, given when authenticating to MariaDB.

Continue reading →

In MariaDB, SESSION_USER() is a synonym for the USER() function. It returns the current MariaDB user name and host name, given when authenticating to MariaDB.

Continue reading →

In MariaDB, CURRENT_USER() is a built-in function that returns the user name and host name combination for the MariaDB account that the server used to authenticate the current client.

Continue reading →

In MariaDB, USER() is a built-in function that returns the current MariaDB user name and host name, given when authenticating to MariaDB.

Continue reading →

In MariaDB, every thread (including each event) has an ID that is unique among the set of currently connected clients. The CONNECTION_ID() function is a built-in function that returns the connection ID (thread ID) for the connection.

Continue reading →

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

It can be used to time how quickly MariaDB processes the expression.

The result is always 0. The function is intended to be used within the mysql command line tool, which reports query execution times.

Continue reading →