SHOW SINGLE TABLE (table | RULES) [FROM databaseName]
SHOW SINGLE TABLES
COUNT SINGLE_TABLE RULE [FROM databaseName]
table:
TABLE tableName
| Column | Description |
|---|---|
| name | Rule name |
| resource_name | Data source name |
| Column | Description |
|---|---|
| table_name | Single table name |
| resource_name | The resource name where the single table is located |
| 列 | 说明 |
|---|---|
| rule_name | Single table rule name |
| database | The database name where the single table is located |
| count | The count of single table rules |
SHOW SINGLE TABLES RULES
sql> SHOW SINGLE TABLES RULES;
+---------+---------------+
| name | resource_name |
+---------+---------------+
| default | ds_1 |
+---------+---------------+
1 row in set (0.01 sec)
SHOW SINGLE TABLE tableName
sql> SHOW SINGLE TABLE t_single_0;
+----------------+---------------+
| table_name | resource_name |
+----------------+---------------+
| t_single_0 | ds_0 |
+----------------+---------------+
1 row in set (0.01 sec)
SHOW SINGLE TABLES
mysql> SHOW SINGLE TABLES;
+--------------+---------------+
| table_name | resource_name |
+--------------+---------------+
| t_single_0 | ds_0 |
| t_single_1 | ds_1 |
+--------------+---------------+
2 rows in set (0.02 sec)
COUNT SINGLE_TABLE RULE
mysql> COUNT SINGLE_TABLE RULE;
+--------------+----------+-------+
| rule_name | database | count |
+--------------+----------+-------+
| t_single_0 | ds | 2 |
+--------------+----------+-------+
1 row in set (0.02 sec)