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:

snippet
USE database_name;

Example:

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

snippet
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.

Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +