大网数据广告活动
数据库部署与 SQL 参考

Apache ShardingSphere 中文参考:SHOW ENCRYPT RULES

· 52CE 我爱测

### 描述 语法用于查询指定逻辑库中的数据加密规则。 ### 语法 ### 补充说明 - 未指定 时,默认是当前使用的 。 如果也未使用 则会提示 。 ### 返回值说明 | 列 | 说明 | |--------------------------|-------------| | table | 逻辑表名 | | logic_column | 逻辑列名 | | cipher_column | 密文列名 | | assisted_qu

描述

SHOW ENCRYPT RULES 语法用于查询指定逻辑库中的数据加密规则。

语法

ShowEncryptRule::=
  'SHOW' 'ENCRYPT' ('RULES' | 'TABLE'? 'RULE' ruleName) ('FROM' databaseName)?

ruleName ::=
  identifier

databaseName ::=
  identifier

补充说明

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

返回值说明

列 说明
table 逻辑表名
logic_column 逻辑列名
cipher_column 密文列名
assisted_query_column 辅助查询列名
like_query_column 模糊查询列名
encryptor_type 加密算法类型
encryptor_props 加密算法参数
assisted_query_type 辅助查询算法类型
assisted_query_props 辅助查询算法参数
like_query_type 模糊查询算法类型
like_query_props 模糊查询算法参数

示例

  • 查询指定逻辑库中的数据加密规则
SHOW ENCRYPT RULES FROM encrypt_db;
mysql> SHOW ENCRYPT RULES FROM encrypt_db;
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
| table     | logic_column | cipher_column | assisted_query_column | like_query_column | encryptor_type | encryptor_props         | assisted_query_type | assisted_query_props | like_query_type | like_query_props |
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
| t_user    | pwd          | pwd_cipher    |                       |                   | AES            | aes-key-value=123456abc, digest-algorithm-name=SHA-1 |                     |                      |                 |                  |
| t_encrypt | pwd          | pwd_cipher    |                       |                   | AES            | aes-key-value=123456abc, digest-algorithm-name=SHA-1 |                     |                      |                 |                  |
+-----------+--------------+---------------+--------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
2 rows in set (0.00 sec)
  • 查询当前逻辑库中的数据加密规则
SHOW ENCRYPT RULES;
mysql> SHOW ENCRYPT RULES;
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
| table     | logic_column | cipher_column | assisted_query_column | like_query_column | encryptor_type | encryptor_props         | assisted_query_type | assisted_query_props | like_query_type | like_query_props |
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
| t_user    | pwd          | pwd_cipher    |                       |                   | AES            | aes-key-value=123456abc, digest-algorithm-name=SHA-1 |                     |                      |                 |                  |
| t_encrypt | pwd          | pwd_cipher    |                       |                   | AES            | aes-key-value=123456abc, digest-algorithm-name=SHA-1 |                     |                      |                 |                  |
+-----------+--------------+---------------+--------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
2 rows in set (0.00 sec)
  • 查询指定逻辑库中指定的数据加密规则
SHOW ENCRYPT TABLE RULE t_encrypt FROM encrypt_db;
mysql> SHOW ENCRYPT TABLE RULE t_encrypt FROM encrypt_db;
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
| table     | logic_column | cipher_column | assisted_query_column | like_query_column | encryptor_type | encryptor_props         | assisted_query_type | assisted_query_props | like_query_type | like_query_props |
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
| t_encrypt | pwd          | pwd_cipher    |                       |                   | AES            | aes-key-value=123456abc, digest-algorithm-name=SHA-1 |                     |                      |                 |                  |
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
1 row in set (0.01 sec)
  • 查询当前逻辑库中指定的数据加密规则
SHOW ENCRYPT TABLE RULE t_encrypt;
mysql> SHOW ENCRYPT TABLE RULE t_encrypt;
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
| table     | logic_column | cipher_column | assisted_query_column | like_query_column | encryptor_type | encryptor_props         | assisted_query_type | assisted_query_props | like_query_type | like_query_props |
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
| t_encrypt | pwd          | pwd_cipher    |                       |                   | AES            | aes-key-value=123456abc, digest-algorithm-name=SHA-1 |                     |                      |                 |                  |
+-----------+--------------+---------------+-----------------------+-------------------+----------------+-------------------------+---------------------+----------------------+-----------------+------------------+
1 row in set (0.01 sec)

保留字

SHOW、ENCRYPT、TABLE、RULE、RULES、FROM

相关链接

本文来自 Apache ShardingSphere 文档贡献者,按 Apache 2.0 整理版式与相对链接,保留正文与代码。图示请参阅原文。作者与贡献记录。

资料来源与适用范围

资料来源
Apache ShardingSphere 文档贡献者
适用范围
master 文档快照(2026-11-16)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-16
授权说明
Apache 2.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。