Is this an undocumented feature that I missed? You just have to specify the
as TYPE_passwd and it will automatically encrypt using that algorithm? I
don't see anything in the documentation for ENCRYPT about this. Or am I
really missing something?
Thanks.
j------ k-----
> mysql> select encrypt('mypass','Az') as DES_passwd;
> +---------------+
> | DES_passwd |
> +---------------+
> | Az7.WJ.dhG.ds |
> +---------------+
> 1 row in set (0.00 sec)
>
> mysql> select encrypt('mypass','$1$') as MD5_passwd;
> +----------------------------+
> | MD5_passwd |
> +----------------------------+
> | $1$$y6yg42JZIjxLYEdRp0CD70 |
> +----------------------------+
> 1 row in set (0.00 sec)
>
> mysql> # dont have blowfish libs
> mysql> select encrypt('mypass','$2$') as Blowfish;
> +----------+
> | Blowfish |
> +----------+
> | : |
> +----------+
> 1 row in set (0.00 sec)
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php