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;

Similar codes

0 vote258 views1 answer
Python mysql check if database exists
SQL
0 vote218 views1 answer
Add plugins to mysql workbench
SQL
0 vote240 views1 answer
Oracle sql add column auto generated value
SQL
3 votes226 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote236 views1 answer
Custom row number
SQL
0 vote231 views1 answer
How change the field place in mysql
SQL
8 votes237 views2 answers
Safe update mode in mysql
SQL
1 vote275 views1 answer
Oracle create program if not exists
SQL
0 vote243 views1 answer
Mysql cli output to a file
SQL
2 votes247 views1 answer
Sql update \
SQL