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 vote210 views1 answer
Sql declare variable single line
SQL
2 votes215 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote209 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
19 votes206 views6 answers
Sql server drop table if exists
SQL
0 vote208 views1 answer
Connecting mySQL to STS
SQL
0 vote166 views1 answer
Online sql compiler
SQL
0 vote239 views1 answer
Show all sequences postgres
SQL
18 votes200 views2 answers
Sql inner join
SQL
0 vote208 views1 answer
Mysql Like(searching in the string)
SQL
0 vote204 views1 answer
Set column width in sqlplus
SQL