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

1 vote180 views1 answer
Mysql get max value and id
SQL
0 vote168 views1 answer
Typeorm raw sql
SQL
0 vote167 views1 answer
What is delimiter in mysql
SQL
0 vote169 views1 answer
Asp.net core sql server stored procedure
SQL
10 votes169 views2 answers
Sql rtrim
SQL
3 votes160 views1 answer
APEX elapsed time
SQL
3 votes171 views2 answers
Df to sql pandas sql achemy
SQL
5 votes197 views1 answer
How to check port number for postgresql
SQL
0 vote165 views1 answer
Alasql delete column
SQL
0 vote285 views1 answer
How to delete duplicate rows in oracle
SQL