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 vote307 views1 answer
Sql server count all tables rows
SQL
17 votes333 views4 answers
Mysql remove ubuntu
SQL
0 vote271 views2 answers
Postgresql could not start server mac
SQL
104 votes521 views2 answers
Like in mysql
SQL
0 vote302 views1 answer
Sql select column names starting with
SQL
0 vote327 views1 answer
Get date from timestamp in mysql
SQL
16 votes328 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
-1 vote316 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote328 views1 answer
Like sql for second letter of the family name
SQL
0 vote315 views1 answer
Désinstaller postgresql linux
SQL