(mysql.info) use

Info Catalog

(mysql.info) describe

(mysql.info) basic-user-commands

 
 13.3.2 `USE' Syntax
 -------------------
 
      USE DB_NAME
 
 The `USE DB_NAME' statement tells MySQL to use the DB_NAME database as
 the default (current) database for subsequent statements. The database
 remains the default until the end of the session or another `USE'
 statement is issued:
 
      USE db1;
      SELECT COUNT(*) FROM mytable;   # selects from db1.mytable
      USE db2;
      SELECT COUNT(*) FROM mytable;   # selects from db2.mytable
 
 Making a particular database the default by means of the `USE'
 statement does not preclude you from accessing tables in other
 databases. The following example accesses the `author' table from the
 `db1' database and the `editor' table from the `db2' database:
 
      USE db1;
      SELECT author_name,editor_name FROM author,db2.editor
        WHERE author.editor_id = db2.editor.editor_id;
 
 The `USE' statement is provided for compatibility with Sybase.
 

Info Catalog

(mysql.info) describe

(mysql.info) basic-user-commands