The COUNT SINGLE_TABLE RULE syntax is used to query number of single table rules for specified database.
CountSingleTableRule::=
'COUNT' 'SINGLE_TABLE' 'RULE' ('FROM' databaseName)?
databaseName ::=
identifier
databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.| 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 |
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)
COUNT, SINGLE_TABLE, RULE