mysql update与group by

最新推荐文章于 2024-05-15 13:53:50 发布

百雨

最新推荐文章于 2024-05-15 13:53:50 发布

阅读量7.2k

点赞数 2

分类专栏： mysql

本文链接：https://blog.csdn.net/sinat_38068807/article/details/107769987

版权

mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

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

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

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

百雨

关注关注

2
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
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_noSET A.domain_count=B.count
复制链接

扫一扫