mysql - UPDATE a column by COUNT of another table ...

2014年1月8日 - and. UPDATE table1 A INNER JOIN (SELECT id,COUNT(*) idcount FROM table2 GROUP BY id) B USING (id) SET A.Freq = B.idcount. mysql ...

dba.stackexchange.com