Use the PASSWORD() MySQL builtin function as follows:
INSERT INTO Table
VALUES ('0', 'username', PASSWORD('password'), 'email')
This function is not part of the SQL standard. It is
used for storing passwords in the MySQL user table in
the mysql database schema named mysql among other things.
Neil
On Sun, 12 May 2002, Jule wrote:
> Hey guys and gals,
> How do i add info to a table, and give a varchar(16) row the function of
> password, so that it is encrypted? my query now is:
> INSERT into table values('0', 'username', 'password', 'email')
>
> thanks
>
> Jule
>
---------------------------------------------------------------------
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
