How to update all the column types in a table...
| From: | Trond Erling Hundal | Date: | Fri, 30 Nov 2001 13:50:47 +0000 |
| Subject: | How to update all the column types in a table... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14717@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?
__ _
/ / (_)__ __ ____ __
/ /__/ / _ \/ // /\ \/ / . . . t h e c h o i c e o f a
/____/_/_//_/\_,_/ /_/\_\ G N U g e n e r a t i o n . . .