(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
automatically generated byinfo2html