Load data infile in a stored procedure- MySQL

Posted by Pankaj on Stack Overflow See other posts from Stack Overflow or by Pankaj
Published on 2010-05-10T11:41:12Z Indexed on 2010/05/10 11:44 UTC
Read the original article Hit count: 292

Filed under:

Is there any way, i can use 'Load data infile' in a stored procedure. I am using mysql.

LOAD DATA LOCAL INFILE 'C:\\MyData.txt' INTO TABLE
tempprod fields terminated by ',' lines terminated by '\r\n';
SELECT * FROM product p;

© Stack Overflow or respective owner

Related posts about mysql