> Use sed. Or Excel/Calc. > > The question is: where do you get the user_id from? > > florin > Figured it out: LOAD DATA *LOCAL* INFILE '//importfile.csv/' INTO TABLE /test_table/ FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3); I added a field for the user id, and things imported properly. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mailman.mn-linux.org/pipermail/tclug-list/attachments/20110408/d2ce2baf/attachment-0001.html>