Select a MySQL database to use

Posted December 14, 2003 by Quinn McHenry in 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.

 

About 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.
View more articles by Quinn McHenry

The Conversation

Follow the reactions below and share your own thoughts.