select ctype,cname from tk order by ctype; 这样按类别排好序,然后在程序处理的时候判断一下当前类别是否=上一个类别(用变量存储),如果不等则说明是新的类型开始,则输出类别名。否则只输入名字即可。mysql> select * from tk; +-------+-------+ | cname | ctype | +-------+-------+ | A | A | | B | B | | C | A | | D | C | | E | A | | F | C | +-------+-------+ 6 rows in set (0.00 sec)mysql> mysql> select ctype,cname from tk order by ctype; +-------+-------+ | ctype | cname | +-------+-------+ | A | A | | A | C | | A | E | | B | B | | C | D | | C | F | +-------+-------+ 6 rows in set (0.00 sec)
这样按类别排好序,然后在程序处理的时候判断一下当前类别是否=上一个类别(用变量存储),如果不等则说明是新的类型开始,则输出类别名。否则只输入名字即可。mysql> select * from tk;
+-------+-------+
| cname | ctype |
+-------+-------+
| A | A |
| B | B |
| C | A |
| D | C |
| E | A |
| F | C |
+-------+-------+
6 rows in set (0.00 sec)mysql>
mysql> select ctype,cname from tk order by ctype;
+-------+-------+
| ctype | cname |
+-------+-------+
| A | A |
| A | C |
| A | E |
| B | B |
| C | D |
| C | F |
+-------+-------+
6 rows in set (0.00 sec)