[mysql] update .. set .. = select .. - Google Groups

Witam Mam taki kod w php: $rows = sql("select id_kraj, count(*) as count from produkty group by id_kraj"); foreach ($rows as $row) { $count = $row['count']; $id = $row['id_kraj']; sql("update kraje set count=$count where id=$id");

groups.google.com