<div>
You can use the LOAD_FILE() function to read the entire file into a variable, and then use a loop to parse each line out of the variable:<br />
<br />
SET @file := LOAD_FILE('path/to/file.cs<wbr />v');<br />
while LOCATE('\n', @file) do...<br />
<br />
It will be much slower than LOAD DATA INFILE would be.
</div>


You can use the LOAD_FILE() function to read the entire file into a variable, and then use a loop to parse each line out of the variable:

SET @file := LOAD_FILE('path/to/file.csv');
while LOCATE('\n', @file) do...

It will be much slower than LOAD DATA INFILE would be.

<div>
Hello,<br />
well thanks for your suggestion,<br />
but what do you mean by variable?<br />
is it a temporary table?<br />
<br />
can you please give more detail about the loop,<br />
thanks
</div>


Hello,
well thanks for your suggestion,
but what do you mean by variable?
is it a temporary table?

can you please give more detail about the loop,
thanks

<div>
<div class="content wysiwyg-content">
Hello,<br />
I want to load data from a csv file to a MySQL table,<br />
I want to perform this operation within a Stored Procedure.<br />
I tried :<br />
LOAD DATA INFILE,<br />
but i have an error saying that i cannot use LOAD DATA from a Stored procedure.<br />
<br />
Do I have any alternative method that i can use in a Stored procedure?<br />
thanks
</div>
</div>


Hello,
I want to load data from a csv file to a MySQL table,
I want to perform this operation within a Stored Procedure.
I tried :
LOAD DATA INFILE,
but i have an error saying that i cannot use LOAD DATA from a Stored procedure.

Do I have any alternative method that i can use in a Stored procedure?
thanks

using : LOAD DATA INFILE in MySQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.