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

11 votes273 views1 answer
Creating tables in sql with python
SQL
1 vote266 views1 answer
T-sql disable system versioning
SQL
0 vote269 views1 answer
How to check database engine in mysql
SQL
0 vote241 views1 answer
How to insert same table data using mysql query
SQL
0 vote249 views1 answer
Sub blocks in sql
SQL
1 vote253 views1 answer
Sql Split string function
SQL
0 vote206 views1 answer
Finish transaction sql
SQL
0 vote262 views1 answer
Postgresql interview questions
SQL
12 votes257 views5 answers
Sql merge
SQL
12 votes251 views1 answer
Docker run mysql image
SQL