SHOW MASK RULES

语法

• 未指定 databaseName 时，默认是当前使用的 DATABASE， 如果也未使用 DATABASE 则会提示 No database selected。

返回值说明

• 查询指定逻辑库中的所有数据脱敏规则

SHOW MASK RULES FROM mask_db;

mysql> SHOW MASK RULES FROM mask_db;
+---------+----------+------------------+--------------------------------+
| table   | column   | algorithm_type   | algorithm_props                |
+---------+----------+------------------+--------------------------------+
| t_mask  | address  | MD5              |                                |
| t_order | order_id | MD5              |                                |
+---------+----------+------------------+--------------------------------+
4 rows in set (0.01 sec)

• 查询当前逻辑库中的所有数据脱敏规则

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)

• 查询指定逻辑库中的指定数据脱敏算法

• 查询当前逻辑库中的指定数据脱敏算法

SHOW MASK RULE t_mask;

mysql> SHOW MASK RULE t_mask;
+--------+--------------+------------------+--------------------------------+
| table  | logic_column | mask_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)

保留字