[EMAIL PROTECTED] (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:


(don't know how long the field needs to be).

UPDATE foo SET bar = MD5(baz);

"Spare no expense to save money on this one."
                -- Samuel Goldwyn

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to