MySQL下的加密解密函数AES_DECRYPT

drop table t_passwd;
mysql> CREATE TABLE t_passwd (pass1 blob,pass2 blob, pass3 blob);

mysql> INSERT INTO t_passwd VALUES (AES_ENCRYPT('明文1', 'key'), AES_ENCRYPT('text2', 'key'), AES_ENCRYPT('明文_text3', 'key'));
select * from t_passwd;
mysql> select * from t_passwd;
+------------------------------------+------------------------------------+------------------------------------+
| pass1                              | pass2                              | pass3                              |
+------------------------------------+------------------------------------+------------------------------------+
| 0x9B1A7A1DC71307D779C93ACA5E125FC0 | 0x2596985B5DDE5969DA03DC201BF39FD6 | 0x38F53F82C6025297E06076CD6237FBDE |
+------------------------------------+------------------------------------+------------------------------------+
1 row in set (0.00 sec)

SELECT AES_DECRYPT(pass1, 'key'), AES_DECRYPT(pass2, 'key'), AES_DECRYPT(pass3, 'key') FROM t_passwd;

 
mysql> SELECT AES_DECRYPT(pass1, 'key'), AES_DECRYPT(pass2, 'key'), AES_DECRYPT(pass3, 'key') FROM t_passwd;
+------------------------------------------------------+------------------------------------------------------+------------------------------------------------------+
| AES_DECRYPT(pass1, 'key')                            | AES_DECRYPT(pass2, 'key')                            | AES_DECRYPT(pass3, 'key')                            |
+------------------------------------------------------+------------------------------------------------------+------------------------------------------------------+
| 0xE6988EE6968731                                     | 0x7465787432                                         | 0xE6988EE696875F7465787433                           |
+------------------------------------------------------+------------------------------------------------------+------------------------------------------------------+
1 row in set (0.00 sec)
复制