Solved

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

Posted on 2013-01-21
2
1,643 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Let’s list some of the technologies that enable smooth teleworking. 
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…
This video demonstrates how to use each tool, their shortcuts, where and when to use them, and how to use the keyboard to improve workflow.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

734 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