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

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.