USE db_name
The USE
statement tells MySQL to use the named database as the default (current) database for subsequent statements. USE
语句告诉MySQL使用命名数据库作为后续语句的默认(当前)数据库。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:USE
语句之前,命名数据库将保持默认状态:
USE db1; SELECT COUNT(*) FROM mytable; # selects from db1.mytable USE db2; 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.不支持数据库名称中的换行符。
Making a particular database the default by means of the 通过USE
statement does not preclude accessing tables in other databases. USE
语句将特定数据库设为默认数据库并不排除访问其他数据库中的表。The following example accesses the 以下示例从author
table from the db1
database and the editor
table from the db2
database:db1
数据库访问author
表,从db2
数据库访问editor
表:
USE db1; SELECT author_name,editor_name FROM author,db2.editor WHERE author.editor_id = db2.editor.editor_id;