Append new rows from a txt file into a MySQL table which already has data

Asked Feb 13 '17 at 10:43

Active Feb 13 '17 at 13:18

Viewed 658 times

I have got a MySQL table, call it TEST, which already has some 500K rows of data. I wish to append new rows present in the text file, say ABCD.txt, to TEST. The file ABCD.txt also has some 700K rows of data.

I can think of a solution which is exporting data in a txt file from TEST, merging it with ABCD.txt and finally uploading it back in TEST.

Is there another way I can do that efficiently?

P.S. --> I am using command line to load data into TEST

Thanks Neeraj

edited Feb 13 '17 at 13:18

Dan Guzman

35,410
3
30
55

asked Feb 13 '17 at 10:43

Neeraj Saxena

The answer is yes – RiggsFolly Feb 13 '17 at 10:56
Hi, can you let me know what the efficient way would be? – Neeraj Saxena Feb 13 '17 at 11:06
1

Read text file, check for duplicates, insert new rows – RiggsFolly Feb 13 '17 at 11:07
Use the `ignore`-keyword: [MYSQL LOAD DATA INFILE ignore duplicate rows (autoincrement as primary key)](http://stackoverflow.com/questions/12891337/mysql-load-data-infile-ignore-duplicate-rows-autoincrement-as-primary-key) – Solarflare Feb 13 '17 at 12:03

Append new rows from a txt file into a MySQL table which already has data

0 Answers0