Is it possible to append the data from csv file to the existing mysql table

Question

I have a mysql table to which i have imported a csv file and if i try to import another csv file to the same mysql table will it replace the previous data or gets appended????

It gets appended. it will not harm your existing records unless you have some sort of key defined in the table (like unique key... In that case you need to mention 'REPLACE' in your import query) — Priyanshu
– Priyanshu, Commented May 24, 2016 at 6:02
I'd say that depends on how you import that CSV data. Why don't you simply try it with a test table? — arkascha
– arkascha, Commented May 24, 2016 at 6:02
import is like insert its not affect your previous data .it just appending — JYoThI
– JYoThI, Commented May 24, 2016 at 6:06
I have made id of the table as a primary key and it is auto incremented and when i import csv file the id will be auto incremented right??? — Sanjay Hp
– Sanjay Hp, Commented May 24, 2016 at 6:07
yes , You are right. in your case data will be appended. It wont do any harm to existing data, plus your id will be auto_incremented, no need to mention it in the query — Priyanshu
– Priyanshu, Commented May 24, 2016 at 6:17

Adrian · Accepted Answer · 2016-05-24 07:19:31Z

3

CSV imports get treated as an INSERT statement which means no UPDATE is performed.

answered May 24, 2016 at 7:19

Adrian

4524 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to append the data from csv file to the existing mysql table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related