本文共 191 字，大约阅读时间需要 1 分钟。

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

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_noSET A.domain_count=B.count

转载地址：http://vkwsi.baihongyu.com/