> I need to change a varchar into password(varchar) for a password column.
> What is the common SQL syntax to do this.
>
> The table allready has all of the password's stored. I just need to
encrypt
> them with password($value)
>
> ...Or will I have to just make a php script to extract and update?
UPDATE table SET password_column = PASSWORD('password_column');
That 'should' work for you....untested code though. Back up your table data
first =)
Sincerely,
Craig Vincent
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
