PASSWORD()£º´´½¨Ò»¸ö¾¹ý¼ÓÃܵÄÃÜÂë×Ö·û´®£¬ÊʺÏÓÚ²åÈëµ½MySQLµÄ°²È«Ïµ
ͳ¡£¸Ã¼ÓÃܹý³Ì²»¿ÉÄ棬ºÍunixÃÜÂë¼ÓÃܹý³ÌʹÓò»Í¬µÄËã·¨¡£Ö÷ÒªÓÃÓÚMySQLµÄÈÏ֤ϵͳ¡£
ENCRYPT(£¬)£ºÊ¹ÓÃUNIX crypt()ϵͳ¼ÓÃÜ×Ö·û´®£¬ENCRYPT()º¯Êý½ÓÊÕÒª¼ÓÃܵÄ×Ö·û´®ºÍ£¨¿ÉÑ¡µÄ£©ÓÃÓÚ¼ÓÃܹý³ÌµÄsalt£¨Ò»¸ö¿ÉÒÔΨһȷ¶¨¿ÚÁîµÄ×Ö·û´®£¬¾ÍÏñÔ¿³×Ò»Ñù£©£¬×¢Ò⣬windowsÉϲ»Ö§³Ö
ENCODE(,) DECODE(,)£º¼ÓÃܽâÃÜ×Ö·û´®¡£¸Ãº¯ÊýÓÐÁ½¸ö²ÎÊý£º±»¼ÓÃÜ»ò½âÃܵÄ×Ö·û´®ºÍ×÷Ϊ¼ÓÃÜ»ò½âÃÜ»ù´¡µÄÃÜÔ¿¡£Encode½á¹ûÊÇÒ»¸ö¶þ½øÖÆ×Ö·û´®£¬ÒÔBLOBÀàÐÍ´æ´¢¡£¼ÓÃܳɶ¼Ïà¶Ô±È½ÏÈõ
MD5()£º¼ÆËã×Ö·û´®µÄMD5УÑéºÍ£¨128룩
SHA5()£º¼ÆËã×Ö·û´®µÄSHA5УÑéºÍ£¨160룩
ÒÔÉÏÁ½¸öº¯Êý·µ»ØµÄУÑéºÍÊÇ16½øÖƵģ¬ÊʺÏÓëÈÏ֤ϵͳÖÐʹÓõĿÚÁî¡£
Eg£ºSELECT * FROM USERS WHERE NAME=¡¯JOHN¡¯ AND PASSWORD=MD5(¡®MYPASS¡¯);