ÇóÒ»sqlÓï¾ä - PHP / »ù´¡±à³Ì

ÓÐÈýÕűí A,B,C
AÀïÃæ×Ö¶ÎÁ½¸öproducts_id£¨int£©ºÍproducts_model£¨varchar£©
BºÍC±íÀïÃ涼ÓÐproducts_idÕâ¸ö×ֶκÍA±íÀïÃæµÄproducts_idÊǹØÁªµÄ

±ÈÈçÎÒÏÖÔÚÖªµÀÁËA±íÀïÃæµÄproducts_modelÖµ ÎÒÏëɾ³ýËùÖªµÀµÄproducts_model×ֶεÄËùÓÐÊý¾ÝÒÔ¼°ËûµÄproducts_idµ«Í¬Ê±
BºÍC±íÀïÃæÏà¶ÔÓ¦µÄproducts_idÒ²½øÐÐɾ³ý¡£

---

ÒýÓÃ

SQL code
delete a.*,b.*,c.* from A a
inner join B b on b.products_id = a.products_id
inner join C c on c.products_id = b.products_id
where a.products_model = 'Öµ'

ллÁË

---

ÒýÓÃ

SQL code
delete a.*,b.*,c.* from A a
inner join B b on b.products_id = a.products_id
inner join C c on c.products_id = b.products_id
where a.products_model = 'Öµ'

±ÈÈçproducts_modelÕâ¸öÖµºÜ¶àÀ² ¸ÃÔõô¸ÄдÀ²¸Õ²Å×Ô¼º¸ÄдÁË ÌáʾÓï·¨´íÎó ¡£ÓôÃÆ

---

ÎÒµÄÒâ˼products_model¼ÙÈçÊÇ200¶à¸öÕâÖÖµÄÓï¾äʵÏÖÆðÀ´±È½ÏÂé·³ ÎҸղŸÄÁËÏ µ«ÌáʾÓï·¨´íÎó

---

delete zen_products.*,zen_products_discount_quantity.*,zen_products_notifications.* from zen_products a 
inner join zen_products_discount_quantity b on b.products_id = a.products_id
inner join zen_products_notifications c on c.products_id = b.products_id
where a.products_model = '089566'

±¨´í£º1109 - Unknown table 'zen_products' in MULTI DELETE