SHOW SHADOW RULE

Description

The SHOW SHADOW RULE syntax is used to query shadow rules for specified database.

Syntax

Grammar Railroad diagram

  1. ShowEncryptRule::=
  2.   'SHOW' 'SHADOW' ('RULES' | 'RULE' shadowRuleName) ('FROM' databaseName)?
  4. shadowRuleName ::=
  5.   identifier
  7. databaseName ::=
  8.   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
rule_nameShadow rule name
source_nameData source name
shadow_nameShadow data source name
shadow_tableShadow table

Example

  • Query specified shadow rule in specified database.
  1. SHOW SHADOW RULE shadow_rule FROM shadow_db;
  1. mysql> SHOW SHADOW RULE shadow_rule FROM shadow_db;
  2. +-------------+-------------+-------------+----------------------+
  3. | rule_name   | source_name | shadow_name | shadow_table         |
  4. +-------------+-------------+-------------+----------------------+
  5. | shadow_rule | ds_0        | ds_1        | t_order_item,t_order |
  6. +-------------+-------------+-------------+----------------------+
  7. 1 row in set (0.00 sec)
  • Query specified shadow rule in current database.
  1. SHOW SHADOW RULE shadow_rule;
  1. mysql> SHOW SHADOW RULE shadow_rule;
  2. +-------------+-------------+-------------+----------------------+
  3. | rule_name   | source_name | shadow_name | shadow_table         |
  4. +-------------+-------------+-------------+----------------------+
  5. | shadow_rule | ds_0        | ds_1        | t_order_item,t_order |
  6. +-------------+-------------+-------------+----------------------+
  7. 1 row in set (0.01 sec)
  • Query shadow rules for specified database.
  1. SHOW SHADOW RULES FROM shadow_db;
  1. mysql> SHOW SHADOW RULES FROM shadow_db;
  2. +-------------+-------------+-------------+----------------------+
  3. | rule_name   | source_name | shadow_name | shadow_table         |
  4. +-------------+-------------+-------------+----------------------+
  5. | shadow_rule | ds_0        | ds_1        | t_order_item,t_order |
  6. +-------------+-------------+-------------+----------------------+
  7. 1 row in set (0.00 sec)
  • Query shadow rules for current database.
  1. SHOW SHADOW RULES;
  1. mysql> SHOW SHADOW RULES;
  2. +-------------+-------------+-------------+----------------------+
  3. | rule_name   | source_name | shadow_name | shadow_table         |
  4. +-------------+-------------+-------------+----------------------+
  5. | shadow_rule | ds_0        | ds_1        | t_order_item,t_order |
  6. +-------------+-------------+-------------+----------------------+
  7. 1 row in set (0.00 sec)

Reserved word

SHOW, SHADOW, RULE, RULES, FROM