MySQL单向加密函数

select encode(pual,zhangxueliang);

 

select md5(zhangxueliang);

 

加密为null,不显示字段值:

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

 

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

 

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