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:

USE database_name; 

Example:

Let’s take an example to use a database name “customers”.

USE customers; 

It will look like this:

mysql select database 1

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.


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *