扫码关注官方订阅号
select pid,count(*) from table1 group by pid;
查出每个 pid 出现的总次数,
问题出来了,
另一个表里放了pid对应的name,
现在需要通过联合查询,直接显示出 ,
每个name出现的总次数
我爱PHP
SELECT a.pid as pid , a.name as name, COUNT(b.pid ) as num FROM `table1` as a, `table2` as b WHERE a.pid = b.pid;
微信扫码关注PHP中文网服务号
QQ扫码加入技术交流群
扫描下载App
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
PHP学习
技术支持
返回顶部
SELECT a.pid as pid , a.name as name, COUNT(b.pid ) as num FROM `table1` as a, `table2` as b WHERE a.pid = b.pid;