Re: Update MD5 field
| From: | Fredrik de Vibe | Date: | Tue, 04 Mar 2003 04:39:27 +0000 |
| Subject: | Re: Update MD5 field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26076@lists.php.net to get a copy of this message | ||
dmatielo@uol.com.br (Dani Matielo) writes:
> 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.
If I understand you correctly, this is probably something like what
you want to do:
ALTER TABLE foo ADD bar VARCHAR(20);
(don't know how long the field needs to be).
UPDATE foo SET bar = MD5(baz);
--
--Fredrik
"Spare no expense to save money on this one."
-- Samuel Goldwyn