I am trying to import not just one but numerous flatfile csv files using LOAD DATA INFILE statement from the mysql command line. Using the code ive posted below i can insert a single .csv file but I need to be able to insert all .csv files that are in the same directory.
Ive tried using *, %, and .*\ as wildcard operators but none of them have worked.
mysql --user=username --password=mypassword LOAD DATA LOCAL INFILE 'c:\\\files\\\\\\date20080808.txt.csv' INTO TABLE mytable FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' (field1, field2, field3)