The COUNT SHADOW RULE syntax is used to query the number of shadow rules for specified database.
CountShadowRule::=
'COUNT' 'SHADOW' '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 | rule type |
| database | the database to which the rule belongs |
| count | the number of the rule |
COUNT SHADOW RULE FROM test1;
mysql> COUNT SHADOW RULE FROM test1;
+-----------+----------+-------+
| rule_name | database | count |
+-----------+----------+-------+
| shadow | test1 | 1 |
+-----------+----------+-------+
1 row in set (0.00 sec)
COUNT SHADOW RULE;
mysql> COUNT SHADOW RULE;
+-----------+----------+-------+
| rule_name | database | count |
+-----------+----------+-------+
| shadow | test1 | 1 |
+-----------+----------+-------+
1 row in set (0.01 sec)
COUNT, SHADOW, RULE, FROM