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” 博客，谢绝转载！

批量update_mysql