問題描述

select查詢數(shù)據(jù)庫里面有幾萬條id數(shù)據(jù)，select id from tb1 where serverindex = 2;223323424353...現(xiàn)在需要根據(jù)上面查詢到的id，把數(shù)據(jù)刪除，有什么快速的方法不用一條一條刪除delete from tb2 where id = 2233...

問題解答

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

這樣不就可以了。。

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

drop database

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

上面的答案通通錯(cuò)誤！對于你來說！你只能安裝Navicat Premium這個(gè)軟件來解決！why，因?yàn)闃巧系亩际腔A(chǔ)知識(shí)！