MySQL Select Database

Last Updated: 02 June, 2023

To select a database in MySQL, you need to use the USE statement. Here's the syntax:

 USE database_name;

Replace database_name with the name of the database we want to select. For example, if we want to select a database called "schoolDB", the command would be:

 USE schoolDB;

After executing this command, all subsequent queries and operations will be performed within the selected database until we switch to a different database using the USE statement again.

Note that we need to have appropriate privileges to access the specified database. If we don't have the necessary privileges, we may receive an error message.