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');