Possible to update records using LOAD DATA LOCAL INFILE...

team2005
team2005 used Ask the Experts™
on
Hi!

Have a table in mysql that contains of 100 000 record.
And i am using ->Dim sSql As String = "LOAD DATA LOCAL INFILE 'C:\\singel\\ordrehoder.txt' into table Ordrer FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';"
To insert new records, and this is working fine :)

My question is this:
Is it possible to UPDATE records using LOAD DATA... ?

Need this ASAP.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial