Is it possible to update a column using LOAD DATA INFILE,when the primary key is set to auto increment.
Whenever i updated my table values in csv file, its getting updated in my mysql table by running this query
Load data local infile 'D:\\Employee.csv'
into Table employee
fields terminated by ','
enclosed by ' '
ignore 1 lines
But this is giving proper result if the primary key is not set to Auto increment.But my issue is it should work even if i set the primary key value to auto increment.
Plz Can anyone suggest me on this?
Thanks in advance
This topic is now archived. It is frozen and cannot be changed in any way.