Solved

How to use LOAD DATA INFILE for Store Procedure Via VB.net

Posted on 2013-01-21
2
1,575 Views
Last Modified: 2013-01-22
HI All,
Im trying to use

LOAD DATA INFILE 'FileName'
IGNORE INTO TABLE TableName
FIELDS TERMINATED BY '","'
LINES TERMINATED BY '\r\n' ;

But it show Load Data Infile not able to use in Store Procedure. Is there any others solution able to let me pump my huge(data size around 2gb) into my MYSQL db?
0
Comment
Question by:AFA-TECH
2 Comments
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 500 total points
ID: 38804084
0
 

Author Closing Comment

by:AFA-TECH
ID: 38808377
Thanks pratima_mcs for the solution.
It able to run now....
Thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Team Foundation Server 8 62
Donating Old Pc and laptop 7 87
Disk Wipe Utility 6 84
problem Installing .net framework 4.5.2 8 9
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifiā€¦
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now