How can you check the current database in MySQL?

To check the current database in MySQL, you can use the following SQL command:

SELECT DATABASE();

When you run this command, it will return the name of the currently selected database. If no database is selected, it will return NULL.

Example

Here’s how you can execute it in the MySQL client:

mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| my_database|
+------------+
1 row in set (0.000 sec)

In this example, my_database is the currently selected database. If you need to switch to a different database, you can use the USE command:

USE database_name;

This command will set the specified database as the current one, allowing you to perform operations on it.