Database.Guide

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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

Read more

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.

Read more