SHOW SHADOW TABLE RULE
Description
The SHOW SHADOW TABLE RULE syntax is used to query shadow table rules for specified database.
Syntax
ShowShadowTableRule::=
'SHOW' 'SHADOW' 'TABLE' ('RULE' tableName | 'RULES') ('FROM' databaseName)?
tableName ::=
identifier
databaseName ::=
identifierSupplement
- When
databaseNameis not specified, the default is the currently usedDATABASE. IfDATABASEis not used,No database selectedwill be prompted.
Return value description
| Column | Description |
|---|---|
| shadow_table | Shadow table |
| shadow_algorithm_name | Shadow algorithm name |
Example
- Query shadow table rules for specified database.
SHOW SHADOW TABLE RULES FROM shadow_db;mysql> SHOW SHADOW TABLE RULES FROM shadow_db;
+--------------+-------------------------------------------------------+
| shadow_table | shadow_algorithm_name |
+--------------+-------------------------------------------------------+
| t_order_item | shadow_rule_t_order_item_value_match |
| t_order | sql_hint_algorithm,shadow_rule_t_order_regex_match |
+--------------+-------------------------------------------------------+
2 rows in set (0.00 sec)- Query a shadow table rule for current database.
SHOW SHADOW TABLE RULE t_order;- Query shadow table rules for current database.
SHOW SHADOW TABLE RULES;mysql> SHOW SHADOW TABLE RULES;
+--------------+-------------------------------------------------------+
| shadow_table | shadow_algorithm_name |
+--------------+-------------------------------------------------------+
| t_order_item | shadow_rule_t_order_item_value_match |
| t_order | sql_hint_algorithm,shadow_rule_t_order_regex_match |
+--------------+-------------------------------------------------------+
2 rows in set (0.01 sec)Reserved word
SHOW, SHADOW, TABLE, RULE, RULES, FROM