Re: [PHP-DB] How to update all the column types in a table... From: Craig Vincent (2bunnyhop <email protected>)
Date: 11/30/01

> 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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>