The examples were created with the MyWAY SQL manager: Download
How to use the DATABASE() function in MySQL and MariaDB databases
In MySQL and MariaDB the DATABASE() function is used to retrieve the name of the currently used database. The function can be used directly in SQL statements or within SQL queries, requires no arguments, and returns a string representing the name of the current database.
The DATABASE() function can be used to easily get the current database name within a query or procedure, for example to switch between databases or to reference objects in the current database. The function can be used to organize queries or statements based on the current database, for example, different queries can be executed or different logic can be applied depending on the database context. When creating dynamic SQL statements, the function is useful to include the current database name in the generated SQL code, allowing for more flexible and dynamic queries that adapt to the current database context.
