CODEWITHSUNDEEP
c#mysql
Christopher Stevenson
Christopher Stevenson

Reputation: 2861

LOAD DATA LOCAL INFILE in C# from memory

Is there a way to use the LOAD DATA LOCAL INFILE command to load data from memory in c#? The closest I can come up with is executing a command like:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

I'm trying to avoid needing to write a file to the disk (fun with permission issues) on the client's system.

Upvotes: 0

Views: 1479

Answers (1)

Mad Dog Tannen
Mad Dog Tannen

Reputation: 7244

No you cant. It must read fom a file on disk. Txt or csv are most common.

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Upvotes: 3

Related Questions