MySQL单向加密函数

select encode('pual','zhangxueliang');

 

select md5('zhangxueliang');

 

加密为null，不显示字段值：

select ENCRYPT("tttt","abcd");

 

select AES_DECRYPT("zhangxueliang","ccddss");

 

select AES_ENCRYPT("zhangxueliang","ccdd");