Hi, I really need help with this. I read from various sources but they are complicated and I do not understand them at all. Is anyone kind enough to help how do I go about it?
Jiaxin
0
Newbie Poster
Recommended Answers
Jump to PostEasiest way - output to csv and then use usual method:
LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);
there are also free sites out there that transform csv into sql.
if looking for excel …
Jump to Posttry this code http://www.daniweb.com/web-development/php/threads/371050 with csv file
All 5 Replies
Reply to this topic
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.