Load data infile in a stored procedure- MySQL
- by Pankaj
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;