Help with Import

[Jim Janovich]

Hello,

Need some help here automating a mysql process.

I have a database with two fields, field1 and field2. I also have a file with a list of email addresses with one email per line. I want to run a nightly cron that imports the file, inserts the email into field1 and imports the SHA1(email) into field2. So field1 has the email and field2 has the SHA1 hash of email.

I tried to use mysqlimport but can't figure how to INSERT the SHA1 of the email into field2.

Any help is greatly appreciated.

Jim