当前位置:Gxlcms > 数据库问题 > 批量update_mysql

批量update_mysql

时间:2021-07-01 10:21:17 帮助过:2人阅读

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

标签:update

人气教程排行