group by 的问题 select a.cityid cityid, b.cityname cityname, count(a.cityid) form city a,thread b where a.cityid=b.cityid group by a.cityid,b.cityname order by a.cityid 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select b.cityid,b.cityname,a.count(cityid) as cut from thread as aleft outer join city as b on a.cityid=b.cityidgroup by b.cityid order by b.cityid select b.cityid,b.cityname,a.count(cityid) as cut from thread as aleft outer join city as b on a.cityid=b.cityidgroup by b.cityid order by b.cityid mysql binlog 数据库设计 有关于char与varchar的疑问? InnoDB复制如何初始化数据?也用LOAD DATA FROM MASTER? 如何用语句在,mysql一个表中添加一个字段 Phpmyadmin 为什么我的MySql在XP和Win2k下都说访问禁止阿 请问如何导出mysql中一个表内的几个指定字段的内容(急用!!) 靠谱的数据库团队 如何执行一次bat就往MySQL中插入一条数据记录执行bat的时间? 急问:如何查找出表的分组中id最大的记录? mysql中如何复制一个表?
left outer join city as b on a.cityid=b.cityid
group by b.cityid order by b.cityid
left outer join city as b on a.cityid=b.cityid
group by b.cityid order by b.cityid