update .. select 相關(guān)子語句請求

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 查詢一個表數(shù)據(jù)，將值賦給另一個表中對應(yīng)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

謝謝樓上，搞定：）