Solved

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

Posted on 2013-01-21
2
1,585 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adobe Customization Wizard XI issues 26 231
remove chinese softwares 22 124
Real VNC setup on Windows 2008 5 54
Cannot change default program for *.txt anymore 5 80
A high-level exploration of how our ever-increasing access to information has changed the way we do our jobs.
Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
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.
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…

813 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

11 Experts available now in Live!

Get 1:1 Help Now