team2005
asked on
Possible to update records using LOAD DATA LOCAL INFILE...
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.tx
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.
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.tx
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.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Visual Basic.NET
Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,
96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER