How would I go about importing several CSV files into a single table? Any advice is greatly appreciated!
amcfarland
0
Newbie Poster
Recommended Answers
Jump to PostIf 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.
All 2 Replies
smantscheff
265
Veteran Poster
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.
drjohn
56
Posting Pro in Training
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.