如何不用一条一条删除MySQL数据

Question

select查询数据库里面有几万条id数据，
select id from tb1 where serverindex = 2;
2233
2342
4353
...
现在需要根据上面查询到的id，把数据删除，有什么快速的方法不用一条一条删除
delete from tb2 where id = 2233...

Answer 1

delete from tb2 where id in (select id from tb1 where serverindex = 2)

这样不就可以了。。

Answer 2

delete from table2 tb2 left join tabele1 tb1 on tb2.id = tab1.id where tb1.serverindex = 2

Answer 3

DELETE FROM TABLE2 TB2 WHERE EXISTS (SELECT 1 FROM TABELE1 TB1 ON TB2.ID = TAB1.ID WHERE TB1.SERVERINDEX = 2)

Answer 4

上面的答案通通错误！对于你来说！你只能安装Navicat Premium这个软件来解决！why，因为楼上的都是基础知识！