MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

MySQL - SELECT DATABASE



When there are multiple databases in the MySQL Schema, then before starting any operation on a given database, that database need to be selected. The MySQL USE clause is used to select any existing database in the MySQL schema.

Syntax

The syntax of selecting database is given below:

USE DatabaseName;

To see the list of databases available in RDBMS, the following command can be used:

SHOW DATABASES;

Example: Select a database

To select a database with name testDB, the following statement can be used:

USE testDB;

To check all the available datasets, SHOW DATABASES; command can be used:

mysql> SHOW DATABASES;
Result:
+-------------+
| Database    |
+-------------+
| SQLExample1 |
| SQLExample2 |
| SQLExample3 |
| SQLExample4 |
| SQLExample5 |
| SQLExample6 |
| SQLExample7 |
| SQLExample8 |
| testDB      |
+-------------+
9 rows in set (0.00 sec)