UPDATE tt AS A INNER JOIN( SELECT label_id, COUNT(*) as nums FROM bb GROUP BY label_id ) as B ON A.id = B.label_id SET A.num= B.nums
分组统计出来的数量,更新到另外一个表的某个字段
最新推荐文章于 2023-09-23 17:19:56 发布
UPDATE tt AS A INNER JOIN( SELECT label_id, COUNT(*) as nums FROM bb GROUP BY label_id ) as B ON A.id = B.label_id SET A.num= B.nums