mysql批量删除数据

Question

表有一个自增id作为主键，一个包含3列的唯一索引(a,b,c)，4个普通索引，表数据量100万的样子。

如果执行：delete from tb_xxx where a=1234 and b=5678 and c=9876

一次删除5000条记录。

这条sql会有问题吗？

Answer 1

DELETE FROM `tb_xxx` WHERE `a` = '1234' AND `b` = '5678' AND `c` = '9876'

There should be no problem, I have deleted 10,000 items.