SHOW SHADOW RULE

    Syntax

    • 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

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

    Reserved word

    SHOW, SHADOW, RULE, RULES,