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.
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.