mysql更新一个表里的字段等于另一个表某字段的值实例 如下所示: update table1 as z left join table2 as zb on z zcatId = zb zcatId set z zcatNa Mysql 2022-04-08 266 点赞 4 评论 403 浏览