Consult how to use the MySQL batch to delete records?-CodePudding

[size=16 px] article use batch insert as shown in figure one hundred thousand record of 597 milliseconds

Then insert replacement for delete, try to delete all records

23599
Execution speed and no open batch effect is the same as don't understand the reason on the Internet to check the along while also didn't appear similar problems here to consult the MySQL great god
Looking forward to reply! Thank you!
[/size]

CodePudding user response:

This table is the id of the primary key, or there is an index?

CodePudding user response:

reference 1st floor AHUA1001 response:

id is the primary key of this table, or there is an index,

yes id is the primary key