Re: Update MD5 Field
| From: | Leif K-Brooks | Date: | Tue, 04 Mar 2003 03:29:46 +0000 |
| Subject: | Re: Update MD5 Field | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-138023@lists.php.net to get a copy of this message | ||
Run the following SQL query:
update TABLE set code = md5(concat(name,email))
Dani Matielo wrote:
Hello, everybody my problem is the following: I just imported a csv file to a MySQL database that contains name and email fields. It has about 9k lines on it and I need a new field that orinally didn't exist called "code" thats suposed to be MD5(name.email) I know how to do this for new data, but I don't know how to update all the old ones I already have there. Thank you in advance, Daniela-- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.