DATABASE

Returns the name of the currently selected database.

If no database is selected, then this function returns NULL.

Syntax

DATABASE()

Return Type

String.

Example

Without a database specified:

SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| NULL       |
+------------+

With a database specified:

USE trades;
SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| trades     |
+------------+

Last modified: February 24, 2023

Was this article helpful?