Select a MySQL database to use
Contributed by qmchenry 
Tagged: MySQL A single instance of MySQL can hold many separate databases. It is important to specify the database to which subsequent commands will be issued.
From within the mysql command (see Connect to a MySQL server using the mysql command for more information), the ‘use’ command selects the named database for use:
use financial
This command will select the database named ‘financial’ for use. Subsequent SQL commands will affect this database. The use command must be used on a separate line with no additional SQL commands.
You may also like -
Display a list of databases on a MySQL server
Connect to a MySQL server using the mysql command
Create a MySQL database
Describe the column structure of a MySQL table
Drop or delete a table in MySQL
Use regular expressions in MySQL SELECT statements
Solve: Can't connect to local MySQL server through socket /tmp/mysql.sock
Create a MySQL user account