359025439 发表于 2018-10-10 08:44:12

批量update_mysql

　　update shop_service_category a,storecore.store_productb
　　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;

页: [1]
查看完整版本: 批量update_mysql