复古 护眼 海天 深邃 暗黑 默认

SHOW SINGLE TABLE

描述

SHOW SINGLE TABLE 语法用于查询指定逻辑库中的单表。

语法

ShowSingleTable::=
  'SHOW' 'SINGLE' ('TABLES' ('LIKE' likeLiteral)?|'TABLE' tableName) ('FROM' databaseName)?

tableName ::=
  identifier

databaseName ::=
  identifier

补充说明

  • 未指定 databaseName 时,默认是当前使用的 DATABASE。 如果也未使用 DATABASE 则会提示 No database selected

返回值说明

说明
table_name 单表名称
storage_unit_name 单表所在的数据源名称

示例

  • 查询指定逻辑库中的指定单表
SHOW SINGLE TABLE t_user FROM sharding_db;
mysql> SHOW SINGLE TABLE t_user FROM sharding_db;
+------------+---------------+
| table_name | resource_name |
+------------+---------------+
| t_user     | ds_0          |
+------------+---------------+
1 row in set (0.00 sec)
  • 查询当前逻辑库中的指定单表
SHOW SINGLE TABLE t_user;
mysql> SHOW SINGLE TABLE t_user;
+------------+-------------------+
| table_name | storage_unit_name |
+------------+-------------------+
| t_user     | ds_0              |
+------------+-------------------+
1 row in set (0.00 sec)
  • 查询指定逻辑库中的单表
SHOW SINGLE TABLES FROM sharding_db;
mysql> SHOW SINGLE TABLES FROM sharding_db;
+------------+-------------------+
| table_name | storage_unit_name |
+------------+-------------------+
| t_user     | ds_0              |
+------------+-------------------+
1 row in set (0.00 sec)
  • 查询当前逻辑库中的单表
SHOW SINGLE TABLES;
mysql> SHOW SINGLE TABLES;
+------------+-------------------+
| table_name | storage_unit_name |
+------------+-------------------+
| t_user     | ds_0              |
+------------+-------------------+
1 row in set (0.00 sec)
  • 查询指定逻辑库中表名以 order_5 结尾的单表
SHOW SINGLE TABLES LIKE '%order_5' FROM sharding_db;
mysql> SHOW SINGLE TABLES LIKE '%order_5' FROM sharding_db;
+------------+-------------------+
| table_name | storage_unit_name |
+------------+-------------------+
| t_order_5  | ds_1              |
+------------+-------------------+
1 row in set (0.11 sec)
  • 查询当前逻辑库中表名以 order_5 结尾的单表
SHOW SINGLE TABLES LIKE '%order_5';
mysql> SHOW SINGLE TABLES LIKE '%order_5';
+------------+-------------------+
| table_name | storage_unit_name |
+------------+-------------------+
| t_order_5  | ds_1              |
+------------+-------------------+
1 row in set (0.11 sec)

保留字

SHOWSINGLETABLETABLESLIKEFROM

相关链接