MySQL加密解密

select sha(123456);select sha1(123456);select sha2(123456,3);select md5(123456);select aes_encrypt('columnName', 'myKey');select aes_decrypt(aes_encrypt('columnName', 'myKey'),'myKey');SELECT ENCODE("columnName","myKey");SELECT DECODE(ENCODE("columnName","myKey"),"myKey");select password('123456');