update store_goods as a
inner join enterprise_shops as b
on a.shop_id=b.id
set a.enterprise_id=b.enterprise_id;
转载于:https://www.cnblogs.com/xiong63/p/9958395.html
update store_goods as a
inner join enterprise_shops as b
on a.shop_id=b.id
set a.enterprise_id=b.enterprise_id;
转载于:https://www.cnblogs.com/xiong63/p/9958395.html