mysql的sql语句怎么写

select FolderId,count(*) count from cp_r_morefolder_url group by FolderId 
通过这条语句，我能找出与每个Folder对应的总记录条数，下面我想把这个count设到另一张表中的一个字段中，
另一张表也有FolderId,通过这个字段与之对应，请教各位高手这个sql语句应该怎么写？
update cp_b_morefolder_url set CountApp = ()

SQL code

update  cp_b_morefolder_url A,
(select FolderId,count(*) co from cp_r_morefolder_url group by FolderId )B
set A.CountApp=B.co
where A.FolderId = B.FolderId