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.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
