Load data for updating
Posted by:
Ajar we
Date: January 04, 2012 12:47AM
Hi all,
Am very new to mySQL,Plz help me to improve my knowledge.I imported data from csv file using
Load data local infile 'D:\\Employee.csv'
into Table employee
fields terminated by ','
enclosed by ' '
ignore 1 lines
(Employee_Name,Employee_Salary)
This is working well.
Now my issue is If i change values in csv file that should be updated in database.for example if i change salary of employee in csv,how to update that in database using load data statement..Plz help me on this..
Thanks in advance
Subject
Views
Written By
Posted
Load data for updating
1575
January 04, 2012 12:47AM
1016
January 04, 2012 11:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.