同时删除多张表的数据 

DELETE
   SaleStore,SaleStoreUser 
FROM 
	sale_store AS SaleStore 
	LEFT JOIN sale_store_user AS SaleStoreUser ON SaleStoreUser.store_id = SaleStore.store_id 
WHERE 
	SaleStore.store_id = 3454

　　

posted @ 2017-11-07 15:06  三七、  阅读(2875)  评论(0)    收藏  举报