表 A 更新字段 A.tongji_number 关联字段 ID
表 B 关联字段 AID
目的是表A关联表B 拿到A相关的统计数据放入到tongji_number字段中
"UPDATE table_a AS a SET a.tongji_number = (SELECT COUNT(b.id) FROM table_b AS b WHERE b.aid = a.id )"
表 A 更新字段 A.tongji_number 关联字段 ID
表 B 关联字段 AID
目的是表A关联表B 拿到A相关的统计数据放入到tongji_number字段中
"UPDATE table_a AS a SET a.tongji_number = (SELECT COUNT(b.id) FROM table_b AS b WHERE b.aid = a.id )"