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:

Example:

Let's take an example to use a database name "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.






Latest Courses