How do I load multi data files into MySQL with specified fields?

Question

I've bunch of txt files like this:

aaaa bbbb cccc xxxx dddd eeee yyyy ffff
aaaa bbbb cccc xxxx dddd eeee yyyy ffff
aaaa bbbb cccc xxxx dddd eeee yyyy ffff

Now I want to use LOAD DATA IN FILE command of MySQL, but how do I apply this with multi files ?

And, I don't need xxxx and yyyy in these files.

Here is [how to ignore some columns from your source file](http://stackoverflow.com/a/2139097/1446005). — RandomSeed, Jul 24 '13 at 17:48

score 0 · Accepted Answer · answered Jul 24 '13 at 17:29

0

Use a simple shell command:

ls *.txt | awk '{printf("LOAD DATA INFILE \'%s\' INTO TABLE tablename;\n", $0)}' |
    mysql -u user -p password db_name

answered Jul 24 '13 at 17:29

Barmar

1 Answers1