Count how many rows loaded LOAD DATA INFILE

Question

I have a text file with names in the following format,

firstname:lastname

Here is the query that I run,

$this->db->query("LOAD DATA INFILE 'names.txt' INTO TABLE names FIELDS TERMINATED BY ':' (firstname, lastname)");

How can I calculate how many rows were inserted?

Answer 1

from the manual

When the LOAD DATA INFILE statement ends, it returns string information in the following format:

Records: 1  Deleted: 0  Skipped: 0  Warnings: 0

If you use the C API, you can get approval information by calling the mysql_info () function.

try using mysql_info ()

like:

 $info_str = mysql_info($$link);
    if (ereg("Records: ([0-9]*)", $info_str, $count) == false) {
        ereg("Rows matched: ([0-9]*)", $info_str, $count);
    }

Answer 2

You can run the following query:

 SELECT ROW_COUNT()

He will answer your question.

Answer 3

@rkosegi - ROW_COUNT () only works with SQL_CALC_FOUND_ROWS in SELECT statements.