Hi,
I am trying to import data from text files to MySQL tables. I know by using load data infile, one can populate a table with data in a text file. But what if my data is stored in individual files (each record is in its own file), not all data in one text file, how do I import that data into the table?
Should I try to gather all the data in one text file first and use load data infile command or is there a way that I can try to load data from individual files?
Thanks for your help!!
I am trying to import data from text files to MySQL tables. I know by using load data infile, one can populate a table with data in a text file. But what if my data is stored in individual files (each record is in its own file), not all data in one text file, how do I import that data into the table?
Should I try to gather all the data in one text file first and use load data infile command or is there a way that I can try to load data from individual files?
Thanks for your help!!