Answers for "mysql faster delete"

SQL
0

mysql faster delete

rule of thumb:
delete 1000 rows at a time.
check affected rows until zero.

example:
delete from `atable` where afield like '%something%' limit 0,1000;
Posted by: Guest on October-09-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language