HomeDatabaseMySQLSelect a MySQL database to use

Select a MySQL database to use

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.

Quinn McHenry
Quinn McHenry
Quinn was one of the original co-founders of Tech-Recipes. He is currently crafting iOS applications as a senior developer at Small Planet Digital in Brooklyn, New York.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android