How would I go about importing several CSV files into a single table? Any advice is greatly appreciated!

Recommended Answers

If they have all the same structure just concatenate them into one file and import it.
If this is not sufficient, have a look at the LOAD DATA INFILE command and the mysqlimport utility.

Jump to Post

All 2 Replies

If they have all the same structure just concatenate them into one file and import it.
If this is not sufficient, have a look at the LOAD DATA INFILE command and the mysqlimport utility.

write a series of queries, each one runing one after the other, on a separate line. Run these queries vai a script of a remote access database manager such as heidiSQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.