MYSQL Import from CSV

[chaneguye]

Hi,

I've got a pickle here. I need to import data from a CSV file to a mysql database. I've done this plenty of times with mysqlimport however, here's the catch... I'd like to import this data and ADD it to an existing table without overwriting the table. There are also fields within the table which will not be updated from the CSV.

Any ideas?

Thanks!

 

[Leonardo74]

You can't import CSV file without overwriting the table. There is no option in mysqlimport command. Better you can import it to seperate table and combine both tables using SQL query.

Cegonsoft