SHOW SHADOW TABLE RULES

Description

The SHOW SHADOW TABLE RULES syntax is used to query shadow table rules for specified database.

Syntax

Grammar Railroad diagram

  1. ShowEncryptRule::=
  2.   'SHOW' 'SHADOW' 'TABLE' 'RULES' ('FROM' databaseName)?
  4. databaseName ::=
  5.   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

ColumnDescription
shadow_tableShadow table
shadow_algorithm_nameShadow algorithm name

Example

  • Query shadow table rules for specified database.
  1. SHOW SHADOW TABLE RULES FROM shadow_db;
  1. mysql> SHOW SHADOW TABLE RULES FROM shadow_db;
  2. +--------------+-------------------------------------------------------+
  3. | shadow_table | shadow_algorithm_name                                 |
  4. +--------------+-------------------------------------------------------+
  5. | t_order_item | shadow_rule_t_order_item_value_match                  |
  6. | t_order      | sql_hint_algorithm,shadow_rule_t_order_regex_match |
  7. +--------------+-------------------------------------------------------+
  8. 2 rows in set (0.00 sec)
  • Query shadow table rules for current database.
  1. SHOW SHADOW TABLE RULES;
  1. mysql> SHOW SHADOW TABLE RULES;
  2. +--------------+-------------------------------------------------------+
  3. | shadow_table | shadow_algorithm_name                                 |
  4. +--------------+-------------------------------------------------------+
  5. | t_order_item | shadow_rule_t_order_item_value_match                  |
  6. | t_order      | sql_hint_algorithm,shadow_rule_t_order_regex_match |
  7. +--------------+-------------------------------------------------------+
  8. 2 rows in set (0.01 sec)

Reserved word

SHOW, SHADOW, TABLE, RULES, FROM