请教一条sql语句 本帖最后由 mdjsy1991 于 2010-05-05 13:29:38 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 改count(*) 为count(b.aid) mysql> select a.aid,a.name,a.title,count(b.aid) as count from bb b -> right join aa a on a.aid=b.aid -> group by a.name -> order by a.name;+------+------+-------+-------+| aid | name | title | count |+------+------+-------+-------+| 1 | 111 | 111 | 2 || 2 | 222 | 222 | 1 || 3 | 333 | 333 | 3 || 4 | 444 | 444 | 0 || 5 | 555 | 555 | 0 || 6 | 666 | 666 | 0 |+------+------+-------+-------+6 rows in set (0.00 sec)mysql> 求一个高效率的查询语句。 sql 语法请教 mysql中有没有类似于connect by这样的解决层递搜索的(如此例)(急) 倾家荡产咨询数据库的学习步骤,高手请进 JSP连接 MySQL 数据库问题! 英文好的朋友,进来帮忙看看. 求助:mysql 表插入问题! 统计一条记录某项字段不过空的总数 穷疯了,便宜出卖公司网站空间! service mysql start报错 exists该如何优化 急求一个触发器
-> right join aa a on a.aid=b.aid
-> group by a.name
-> order by a.name;
+------+------+-------+-------+
| aid | name | title | count |
+------+------+-------+-------+
| 1 | 111 | 111 | 2 |
| 2 | 222 | 222 | 1 |
| 3 | 333 | 333 | 3 |
| 4 | 444 | 444 | 0 |
| 5 | 555 | 555 | 0 |
| 6 | 666 | 666 | 0 |
+------+------+-------+-------+
6 rows in set (0.00 sec)mysql>