menghaoranss edited a comment on issue #10454:
URL: 
https://github.com/apache/shardingsphere/issues/10454#issuecomment-848662332


   **SHOW ENCRYPT TABLE RULE t_order (from schemaName)?**
   
   ```
   mysql> show encrypt table rule t_encrypt;
   
+-----------+-------------+--------------+-------------+---------------+-------------------------+
   | table     | logicColumn | cipherColumn | plainColumn | encryptorType | 
encryptorProps          |
   
+-----------+-------------+--------------+-------------+---------------+-------------------------+
   | t_encrypt | order_id    | order_cipher | NULL        | MD5           |     
                    |
   | t_encrypt | user_id     | user_cipher  | user_plain  | AES           | 
aes-key-value=123456abc |
   
+-----------+-------------+--------------+-------------+---------------+-------------------------+
   2 rows in set (0.00 sec)
   
   mysql> show encrypt table rule t_encrypt from encrypt_db;
   
+-----------+-------------+--------------+-------------+---------------+-------------------------+
   | table     | logicColumn | cipherColumn | plainColumn | encryptorType | 
encryptorProps          |
   
+-----------+-------------+--------------+-------------+---------------+-------------------------+
   | t_encrypt | order_id    | order_cipher | NULL        | MD5           |     
                    |
   | t_encrypt | user_id     | user_cipher  | user_plain  | AES           | 
aes-key-value=123456abc |
   
+-----------+-------------+--------------+-------------+---------------+-------------------------+
   2 rows in set (0.00 sec)
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to