Skip to content
User Manual
DistSQL
Syntax
RQL Syntax
Rule Query
Mask
SHOW MASK RULES

SHOW MASK RULES

Description

The SHOW MASK RULES syntax is used to query mask rules for specified database.

Syntax

ShowMaskRule::=
  'SHOW' 'MASK' 'TABLE'? ('RULE' ruleName | 'RULES') ('FROM' databaseName)?

ruleName ::=
  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
table Table name
column Column name
algorithm_type Mask algorithm type
algorithm_props Mask algorithm properties

Example

  • Query mask rules for specified database
SHOW MASK RULES FROM mask_db;
mysql> SHOW MASK RULES FROM mask_db;
+---------+----------+------------------+--------------------------------+
| table   | column   | algorithm_type   | algorithm_props                |
+---------+----------+------------------+--------------------------------+
| t_mask  | phoneNum | MASK_FROM_X_TO_Y | to-y=2,replace-char=*,from-x=1 |
| t_mask  | address  | MD5              |                                |
| t_order | order_id | MD5              |                                |
| t_user  | user_id  | MASK_FROM_X_TO_Y | to-y=2,replace-char=*,from-x=1 |
+---------+----------+------------------+--------------------------------+
4 rows in set (0.01 sec)
  • Query mask rules for current database
SHOW MASK RULES;
mysql> SHOW MASK RULES;
+---------+----------+------------------+--------------------------------+
| table   | column   | algorithm_type   | algorithm_props                |
+---------+----------+------------------+--------------------------------+
| t_mask  | phoneNum | MASK_FROM_X_TO_Y | to-y=2,replace-char=*,from-x=1 |
| t_mask  | address  | MD5              |                                |
| t_order | order_id | MD5              |                                |
| t_user  | user_id  | MASK_FROM_X_TO_Y | to-y=2,replace-char=*,from-x=1 |
+---------+----------+------------------+--------------------------------+
4 rows in set (0.01 sec)
  • Query specified mask rule for specified database
SHOW MASK RULE t_mask FROM mask_db;
mysql> SHOW MASK RULE t_mask FROM mask_db;
+--------+----------+------------------+--------------------------------+
| table  | column   | algorithm_type   | algorithm_props                |
+--------+----------+------------------+--------------------------------+
| t_mask | phoneNum | MASK_FROM_X_TO_Y | to-y=2,replace-char=*,from-x=1 |
| t_mask | address  | MD5              |                                |
+--------+----------+------------------+--------------------------------+
2 rows in set (0.00 sec)
  • Query specified mask rule for current database
SHOW MASK RULE t_mask;
mysql> SHOW MASK RULE t_mask;
+--------+----------+------------------+--------------------------------+
| table  | column   | algorithm_type   | algorithm_props                |
+--------+----------+------------------+--------------------------------+
| t_mask | phoneNum | MASK_FROM_X_TO_Y | to-y=2,replace-char=*,from-x=1 |
| t_mask | address  | MD5              |                                |
+--------+----------+------------------+--------------------------------+
2 rows in set (0.00 sec)

Reserved word

SHOW, MASK, TABLE, RULE, RULES, FROM

Related links

COUNT MASK RULE