php - Mysql bulk insert not inserting all data -

i have insert many data excel table (about 4000 rows ) throught ajax inside loop use :

$query = "insert ignore ".$params["table"]." (".$colonnes_string.") values (".$row.")"; 

this query works fine insert 1000 rows of 4000, may insert have error why set ignore statement, still not insert above 1000 rows.

how can skip insert error , continue query ?

thank you.

please use insert... on duplicate key update syntax instead of ignore here's link similar question https://softwareengineering.stackexchange.com/questions/238472/how-to-insert-update-a-large-amount-of-data-into-mysql-using-php