How to keep old values during mysql LOAD DATA?

Asked Jul 05 '18 at 13:32

Active Jul 05 '18 at 13:32

Viewed 206 times

I'm using the following to batch insert csv data to a mysql table:

LOAD DATA LOCAL INFILE '' REPLACE into table persons 
      (firstname, lastname, age)

persons.csv:

#first,last,age
john,doe,32
jane,done,22

database table:

firstname, lastname, age, birthday

Question: how can I replace existing rows, but KEEP the birthday row if already set?

I using as above, the birthday row will always contain NULL values, no matter if a value existed in that field before insertion.

asked Jul 05 '18 at 13:32

membersound

You can create a data copy in a temp table & then after import you can update birthday from temp table. – Darpan Chhatravala Jul 05 '18 at 13:58
so there is no chance I could achieve this using `LOAD DATA`? – membersound Jul 05 '18 at 14:17
Is there any unique key into the table? – Darpan Chhatravala Jul 05 '18 at 14:23
You can also review https://stackoverflow.com/a/25771546/6318514 – Darpan Chhatravala Jul 05 '18 at 14:24
there is no single unique key in the table, but a composite primary key constraint. – membersound Jul 05 '18 at 20:06

0 Answers0