Retro Eye care Haitian Deep Dark Default

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 ::=
  identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will 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