update oa_customer2 a,oa_admin b set a.xzfzr = b.name where a.uid=b.id and a.xzfzr ='';
mysql 连表更新字段
最新推荐文章于 2024-07-22 15:27:09 发布
update oa_customer2 a,oa_admin b set a.xzfzr = b.name where a.uid=b.id and a.xzfzr ='';