CodesJava

Easy learning with example program codes

Select Database in MySQL

SELECT DATABASE
In MySQL, the USE command is used to select a particular MySQL database to work with.

Syntax:

USE name;   

Parameters:
name: It is used to specify the name of the database to be selected. The database name, table name and table fields’ name in MySQL are case sensitive.

Example:

USE stores;

Output:

Database changed

Explanation:
The ‘stores’ database will be selected.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status