mysql¹ØÁª±í ɾ³ý¶àÓàÊý¾Ý

ÏÖÔÚ±íÓÐA,B
A±íÖÐÓиöB_ID,
ÏÖÔÚ±íAÖÐÓкܶàÊý¾Ý¶ÔÓ¦µÄB_IDÔÚ±íBÖÐÕÒ²»µ½
ÐèҪɾ³ý
sqlÓï¾äÈçºÎд£¿
SQL code:

delete from A where B_ID NOT IN (select ID from B);


ÕâÕűíÓÐ6000ÍòÊý¾Ý£¬2000ÍòÊǶàÓàµÄ
ÓиüºÃµÄsqlÓï¾äÂ𣿣¿£¿

---

delete a from A
left join b on B_ID=b.id
where b.id is null

---

SQL code:

DELETE from A
WHERE NOT EXISTS(SELECT 1 from B WHERE ID=A.B_ID);

---

ÒýÓÃ

or
Ö±½ÓÉú³ÉÒ»¸öбí
create table newtt as
select a.* from a inner join b on a.B_ID=b.id

òËÆÕâ¸ö²»´í

---

Èç¹û b (ID) ÊÇÖ÷¼ü£¬

#3Â¥µÄ·½·¨
SQL code:
DELETE from A
WHERE NOT EXISTS(SELECT 1 from B WHERE ID=A.B_ID);


ÁíÍâ ÕâÕűíÓÐ6000ÍòÊý¾Ý£¬2000ÍòÊǶàÓàµÄ Èç¹ûûÓÐÔ¼ÊøÉϵÄÏÞÖÆ£¬²»ÈçÖؽ¨Ò»¸ö±í£¬Ëٶȷ´¶ø¿ì¡£