MySqli Inserting mass data

php mysql nginx mysqli prepared-statement

The quickest way is LOAD DATA INFILE. Consider creating a file !

But in your case create a tempory table

create table clans_temp like clans;

and insert into that. THEN update the original in one query and delete the temporary table.

As far a i know that is the quickest way given the restrictions of the question.

CodeHunter