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