USE

USE 语句可为用户会话选择当前数据库。

语法图

UseStmt:

UseStmt

DBName:

DBName

示例

USE mysql;
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed
SHOW TABLES;
+----------------------+ | Tables_in_mysql | +----------------------+ | GLOBAL_VARIABLES | | bind_info | | columns_priv | | db | | default_roles | | gc_delete_range | | gc_delete_range_done | | help_topic | | role_edges | | stats_buckets | | stats_feedback | | stats_histograms | | stats_meta | | tables_priv | | tidb | | user | +----------------------+ 16 rows in set (0.00 sec)
CREATE DATABASE newtest;
Query OK, 0 rows affected (0.10 sec)
USE newtest;
Database changed
SHOW TABLES;
Empty set (0.00 sec)
CREATE TABLE t1 (a int);
Query OK, 0 rows affected (0.10 sec)
SHOW TABLES;
+-------------------+ | Tables_in_newtest | +-------------------+ | t1 | +-------------------+ 1 row in set (0.00 sec)

MySQL 兼容性

USE 语句与 MySQL 完全兼容。如发现任何兼容性差异,请在 GitHub 上提交 issue

另请参阅

下载 PDF
产品
TiDB
TiDB Cloud
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.