Retro Eye care Haitian Deep Dark Default

SHOW SHADOW RULE

Description

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

Syntax

ShowShadowRule::=
  'SHOW' 'SHADOW' ('RULES' | 'RULE' shadowRuleName) ('FROM' databaseName)?

shadowRuleName ::=
  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
rule_name Shadow rule name
source_name Data source name
shadow_name Shadow data source name
algorithm_type Shadow algorithm type
algorithm_props Shadow algorithm props

Example

  • Query specified shadow rule in specified database.
SHOW SHADOW RULE shadow_rule FROM shadow_db;

mysql> SHOW SHADOW RULE shadow_rule FROM shadow_db;
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
| shadow_table | rule_name   | source_name | shadow_name | algorithm_type | algorithm_props                                 |
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
| t_order      | shadow_rule | ds_0        | ds_1        | VALUE_MATCH    | column=user_id,operation=insert,value=1         |
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
1 row in set (0.00 sec)
  • Query specified shadow rule in current database.
SHOW SHADOW RULE shadow_rule;

mysql> SHOW SHADOW RULE shadow_rule;
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
| shadow_table | rule_name   | source_name | shadow_name | algorithm_type | algorithm_props                                 |
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
| t_order      | shadow_rule | ds_0        | ds_1        | VALUE_MATCH    | column=user_id,operation=insert,value=1         |
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
1 row in set (0.01 sec)
  • Query shadow rules for specified database.
SHOW SHADOW RULES FROM shadow_db;

mysql> SHOW SHADOW RULES FROM shadow_db;
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
| shadow_table | rule_name   | source_name | shadow_name | algorithm_type | algorithm_props                                 |
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
| t_order      | shadow_rule | ds_0        | ds_1        | VALUE_MATCH    | column=user_id,operation=insert,value=1         |
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
1 row in set (0.00 sec)
  • Query shadow rules for current database.
SHOW SHADOW RULES;

mysql> SHOW SHADOW RULES;
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
| shadow_table | rule_name   | source_name | shadow_name | algorithm_type | algorithm_props                                 |
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
| t_order      | shadow_rule | ds_0        | ds_1        | VALUE_MATCH    | column=user_id,operation=insert,value=1         |
+--------------+-------------+-------------+-------------+----------------+-------------------------------------------------+
1 row in set (0.00 sec)

Reserved word

SHOW, SHADOW, RULE, RULES, FROM