update .. select 相关子语句请求

nogroup

mysql> update group_bookmark as a, group_comment as b set a.commnumber=(select count(1) from group_comment group by shareid) where a.id=b.shareid ;
提示：ERROR 1242 (21000): Subquery returns more than 1 row

group by 查询一个表数据，将值赋给另一个表中对应ID的一个字段，SQL语句报错了。。

apache_test

试试：update group_bookmark as a,(select shareid,count(1)  as cnt from group_comment group by shareid) as b set a.commnumber=b.cnt where a.id=b.shareid

nogroup

谢谢楼上，搞定：）