MySQL SELECT Database

MySQL SELECT Database

SELECT Database is used in MySQL to select a particular database to work with. This query is used when multiple databases are available with MySQL Server.

You can use SQL command USE to select a particular database.

Syntax:

mysql> USE database_name;

Example:

Let's take an example to use a database name "customers".

mysql> USE customers;

It will look like this:

select database

Note: All the database names, table names and table fields name are case sensitive. You must have to use proper names while giving any SQL command.