update shop_service_category a,storecore.store_product b
set a.out_product_id=b.out_product_id
where a.shopid = b.store_id and a.service_category_id = b.service_category_id
and a.is_deleted =0 and b.is_deleted=0;
本文出自 “11898338” 博客，谢绝转载！
原文：http://11908338.blog.51cto.com/11898338/1909222