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