mysql關于加密解密的函數

select?password(‘123456’);?#加密密碼  select?md5(‘123456’);?#md5加密密碼(貌似mysql數據庫相同密碼每次加密后的md5字符串都是一樣

select?AES_ENCRYPT('123456','key')?;?#加密  select?AES_DECRYPT(?(?select?AES_ENCRYPT('123456','key')?),'key')?;?#解密

select?encode('123456','qwedgnkh');?#加密  select?decode(encode?("'123456'","'qwedgnkh'"),"'qwedgnkh'")?#解密