CRMEB系統(tǒng)刪除商品操作比較繁瑣，運(yùn)營(yíng)每次要?jiǎng)h除商品的時(shí)候都會(huì)叨叨開(kāi)發(fā)技術(shù)。不想在去修改刪除邏輯，直接手動(dòng)數(shù)據(jù)庫(kù)刪除想要?jiǎng)h除的全部商品?！緞h庫(kù)有風(fēng)險(xiǎn)，操作需謹(jǐn)慎！?。　?/p>

【刪庫(kù)有風(fēng)險(xiǎn)，操作需謹(jǐn)慎?。?！】

【刪庫(kù)有風(fēng)險(xiǎn)，操作需謹(jǐn)慎！??！】

這里以刪除某個(gè)供應(yīng)商下面的全部商品為例進(jìn)行刪除。需要?jiǎng)h除id為110的供應(yīng)商下面的全部商品，需要?jiǎng)h除以下幾個(gè)表

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);

-- 最后單獨(dú)執(zhí)行這一步  刪除商品表  

-- 最后單獨(dú)執(zhí)行這一步  刪除商品表  

-- 最后單獨(dú)執(zhí)行這一步  刪除商品表  

DELETE FROM  eb_store_product WHERE relation_id = 110

如果需要?jiǎng)h除的是某個(gè)商品的話，直接修改刪除條件就可以了