Retro Eye care Haitian Deep Dark Default

Single Table

Syntax

SHOW SINGLE TABLE (table | RULES) [FROM databaseName]

SHOW SINGLE TABLES

COUNT SINGLE_TABLE RULE [FROM databaseName]

table:
    TABLE tableName

Return Value Description

Single Table Rule

Column Description
name Rule name
resource_name Data source name

Single Table

Column Description
table_name Single table name
resource_name The resource name where the single table is located

Single Table Rule Count

Column Description
rule_name Single table rule name
database The database name where the single table is located
count The count of single table rules

Example

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)