SHOW ENCRYPT RULES [FROM databaseName]
SHOW ENCRYPT TABLE RULE tableName [FROM databaseName]
| Column | Description |
|---|---|
| table | Logical table name |
| logic_column | Logical column name |
| logic_data_type | Logical column data type |
| cipher_column | Ciphertext column name |
| cipher_data_type | Ciphertext column data type |
| plain_column | Plaintext column name |
| plain_data_type | Plaintext column data type |
| assisted_query_column | Assisted query column name |
| assisted_query_data_type | Assisted query column data type |
| encryptor_type | Encryption algorithm type |
| encryptor_props | Encryption algorithm parameter |
| assisted_query_type | Assisted query algorithm type |
| assisted_query_props | Assisted query algorithm parameter |
| like_query_type | Like query algorithm type |
| like_query_props | Like query algorithm parameter |
| query_with_cipher_column | Whether to use encrypted column for query |
Show Encrypt Rules
mysql> SHOW ENCRYPT RULES FROM encrypt_db;
+-------------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
| table | logic_column | logic_data_type | cipher_column | cipher_data_type | plain_column | plain_data_type | assisted_query_column | assisted_query_data_type | encryptor_type | encryptor_props | assisted_query_type | assisted_query_props | like_query_type | like_query_props | query_with_cipher_column |
+-------------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
| t_encrypt | user_id | | user_cipher | | user_plain | | user_assisted | | AES | aes-key-value=123456abc | MD5 | | CHAR_DIGEST_LIKE | | true |
| t_encrypt | order_id | | order_cipher | | | | | | MD5 | | | | | | true |
| t_encrypt_2 | user_id | | user_cipher | | user_plain | | | | AES | aes-key-value=123456abc | | | | | false |
| t_encrypt_2 | order_id | | order_cipher | | | | | | MD5 | | | | | | false |
+-------------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
4 rows in set (0.03 sec)
Show Encrypt Table Rule Table Name
mysql> SHOW ENCRYPT TABLE RULE t_encrypt;
+-----------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
| table | logic_column | logic_data_type | cipher_column | cipher_data_type | plain_column | plain_data_type | assisted_query_column | assisted_query_data_type | encryptor_type | encryptor_props | assisted_query_type | assisted_query_props | like_query_type | like_query_props | query_with_cipher_column |
+-----------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
| t_encrypt | user_id | | user_cipher | | user_plain | | user_assisted | | AES | aes-key-value=123456abc | MD5 | | CHAR_DIGEST_LIKE | | true |
| t_encrypt | order_id | | order_cipher | | | | | | MD5 | | | | | | true |
+-----------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
2 rows in set (0.08 sec)
mysql> SHOW ENCRYPT TABLE RULE t_encrypt FROM encrypt_db;
+-----------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
| table | logic_column | logic_data_type | cipher_column | cipher_data_type | plain_column | plain_data_type | assisted_query_column | assisted_query_data_type | encryptor_type | encryptor_props | assisted_query_type | assisted_query_props | like_query_type | like_query_props | query_with_cipher_column |
+-----------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
| t_encrypt | user_id | | user_cipher | | user_plain | | user_assisted | | AES | aes-key-value=123456abc | MD5 | | CHAR_DIGEST_LIKE | | true |
| t_encrypt | order_id | | order_cipher | | | | | | MD5 | | | | | | true |
+-----------+--------------+-----------------+---------------+------------------+--------------+-----------------+-----------------------+--------------------------+----------------+-------------------------+---------------------+----------------------+------------------+------------------+--------------------------+
2 rows in set (0.03 sec)