How to skip error record while load file processing the INSERT
in PHP,MYSQL.

using load file, we are going to insert records into table, 
table schema is two fields, field one is INT type, field2 is VARCHAR, 

Some time, load file may contain the alphanumeric instead of integer, so while script execute script, just throwing error num and its description.

How set condition, skip the record record and process the load file further .

but here we need, in load field which is bad record and its line number. also how get number rows inserted, deleted and history.
How to skip error record while load file processing the INSERT
===

in PHP,MYSQL.

using load file, we are going to insert records into table, 
table schema is two fields, field one is INT type, field2 is VARCHAR, 

Some time, load file may contain the alphanumeric instead of integer, so while script execute script, just throwing error num and its description.

How set condition, skip the record record and process the load file further .

but here we need, in load field which is bad record and its line number. also how get number rows inserted, deleted and history.