top of page
The USE statement tells MySQL to use the named database as the default
(current) database for subsequent statements. This statement requires
some privilege for the database or some object within it.
The named database remains the default until the end of the session or
another USE statement is issued:
SELECT COUNT(*) FROM mytable; # selects from db1.mytable
SELECT COUNT(*) FROM mytable; # selects from db2.mytable
The database name must be specified on a single line. Newlines in
database names are not supported.
bottom of page