mysql update select 从查询结果中更新数据

# update select 语句(注意:必须使用inner join)
语法 :

UPDATE a
INNER JOIN ( SELECT yy FROM b ) c ON a.id = c.id 
SET a.xx = c.yy

样例:

-- SQL1(分组统计表1)
SELECT
	knowledge_id,
	COUNT( 0 ) nums 
FROM
	pro_base_timu_knowledge 
GROUP BY
	knowledge_id;
	
-- SQL2(更新SQL1统计内容到表2)
UPDATE pro_base_knowledge
INNER JOIN ( SELECT knowledge_id, COUNT( 0 ) nums FROM pro_base_timu_knowledge GROUP BY knowledge_id ) b ON pro_base_knowledge.id = b.knowledge_id 
SET pro_base_knowledge.timu_num = b.nums