AES_ENCRYPT

description

Aes 加密函数

Syntax

VARCHAR AES_ENCRYPT(str,key_str[,init_vector])

返回加密后的结果

example

1. MySQL > select to_base64(AES_ENCRYPT('text','F3229A0B371ED2D9441B830D21A390C3'));
2. +--------------------------------+
3. | to_base64(aes_encrypt('text')) |
4. +--------------------------------+
5. | wr2JEDVXzL9+2XtRhgIloA==       |
6. +--------------------------------+
7. 1 row in set (0.010 sec)

9. MySQL> set block_encryption_mode="AES_256_CBC";
10. Query OK, 0 rows affected (0.006 sec)

12. MySQL > select to_base64(AES_ENCRYPT('text','F3229A0B371ED2D9441B830D21A390C3', '0123456789'));
13. +-----------------------------------------------------+
14. | to_base64(aes_encrypt('text', '***', '0123456789')) |
15. +-----------------------------------------------------+
16. | tsmK1HzbpnEdR2//WhO+MA==                            |
17. +-----------------------------------------------------+
18. 1 row in set (0.011 sec)

keywords

AES_ENCRYPT

AES_DECRYPT

description

Aes 解密函数

Syntax

VARCHAR AES_DECRYPT(str,key_str[,init_vector])

返回解密后的结果

example

1. MySQL > select AES_DECRYPT(FROM_BASE64('wr2JEDVXzL9+2XtRhgIloA=='),'F3229A0B371ED2D9441B830D21A390C3');
2. +------------------------------------------------------+
3. | aes_decrypt(from_base64('wr2JEDVXzL9+2XtRhgIloA==')) |
4. +------------------------------------------------------+
5. | text                                                 |
6. +------------------------------------------------------+
7. 1 row in set (0.012 sec)

9. MySQL> set block_encryption_mode="AES_256_CBC";
10. Query OK, 0 rows affected (0.006 sec)

12. MySQL > select AES_DECRYPT(FROM_BASE64('tsmK1HzbpnEdR2//WhO+MA=='),'F3229A0B371ED2D9441B830D21A390C3', '0123456789');
13. +---------------------------------------------------------------------------+
14. | aes_decrypt(from_base64('tsmK1HzbpnEdR2//WhO+MA=='), '***', '0123456789') |
15. +---------------------------------------------------------------------------+
16. | text                                                                      |
17. +---------------------------------------------------------------------------+
18. 1 row in set (0.012 sec)

keywords

1. AES_ENCRYPT, AES_DECRYPT