mysql update与group by

根据域名列表，更新订单表的域名总数量

UPDATE `order` as A INNER JOIN (select COUNT(dns_name)as count,order_no  from domain_email_list GROUP BY order_no) as B ON A.order_no = B.order_no
SET A.domain_count=B.count