How to switch the current database in mysql?

To switch to the current database, you can use the USE statement.

The syntax is as follows:

USE database_name;

database_name is the name of the database to be switched to.

For example, if the current connected database is mydatabase and you want to switch to newdatabase, you can execute the following command:

USE newdatabase;

After switching, all subsequent SQL statements will be executed on the new database.