MariaDB Tutorial MariaDB Advanced MariaDB Database Account Management MariaDB References

MariaDB - SELECT DATABASE



When there are multiple databases in the MariaDB Schema, then before starting any operation on a given database, that database need to be selected. The MariaDB USE statement is used to select any existing database in the MariaDB 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 query can be used:

USE testDB;

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

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

5