Re: How to update all the column types in a table...
| From: | Craig Vincent | Date: | Fri, 30 Nov 2001 16:05:28 +0000 |
| Subject: | Re: How to update all the column types in a table... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14724@lists.php.net to get a copy of this message | ||
> 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