Hello folks,
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’
Replace
into Table employee
fields terminated by ‘,’
enclosed by ’ ’
ignore 1 lines
(Employee_id,Employee_Name,Employee_Salary)
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