MySQL Use Database
MySQL use database command is use for to Open Database. Lets understand How to run SQL use database . First of all connect to MySQL than once it is connected with MySQL , It is used to select one database or in other word it will help to open one database if server has multiple database.
Selecting Database from the Command Prompt
How to Open database ,it is very simple. Once the command prompt appears then in front of mysql> type use “database name”;
This is an example, will open w3htmlschool at command
#mysql -u root -p
mysql> use w3htmlschool;
Above Command will open database at command prompt , It is ready for MySQL command like ,create tables ,show tables etc.