刪除商品

CRMEB系統刪除商品操作比較繁瑣，運營每次要刪除商品的時候都會叨叨開發技術。不想在去修改刪除邏輯，直接手動數據庫刪除想要刪除的全部商品?！緞h庫有風險，操作需謹慎！??！】

【刪庫有風險，操作需謹慎?。?！】

【刪庫有風險，操作需謹慎！?。　?/p>

這里以刪除某個供應商下面的全部商品為例進行刪除。需要刪除id為110的供應商下面的全部商品，需要刪除以下幾個表

DELETE FROM eb_store_product_attr WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);  

DELETE FROM eb_store_product_attr_value WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);

DELETE FROM eb_store_product_attr_result WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);  

DELETE FROM eb_store_product_description WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);  

DELETE FROM eb_store_product_log WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);  

DELETE FROM eb_store_product_relation WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);  

DELETE FROM eb_user_relation WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);  

DELETE FROM eb_store_product_stock_record WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);

-- 最后單獨執行這一步  刪除商品表  

-- 最后單獨執行這一步  刪除商品表  

-- 最后單獨執行這一步  刪除商品表  

DELETE FROM  eb_store_product WHERE relation_id = 110

如果需要刪除的是某個商品的話，直接修改刪除條件就可以了