UPDATE `db01`.`user` AS a
INNER JOIN (
SELECT
COUNT(t.id) AS cjs_count,
t.user_id
FROM
`db02`.`trace` AS t
GROUP BY
t.user_id
) AS b ON a.user_id = b.user_id
SET a.trace_count = b.cjs_count;
这是一个典型的跨库联表更新语句
首先对db02数据库的trace表按照用户id进行汇总,将其统计结果更新至db01数据库的user表