book 表结构
GROUP_CONCAT 用法
1 2 3 4 5 |
SELECT pub_id,GROUP_CONCAT(DISTINCT cate_id) FROM book_mast GROUP BY pub_id ORDER BY GROUP_CONCAT(DISTINCT cate_id) ASC; |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
mysql> SELECT pub_id,GROUP_CONCAT(DISTINCT cate_id) -> FROM book_mast -> GROUP BY pub_id -> ORDER BY GROUP_CONCAT(DISTINCT cate_id) ASC; +--------+--------------------------------+ | pub_id | GROUP_CONCAT(DISTINCT cate_id) | +--------+--------------------------------+ | P003 | CA001,CA003 | | P005 | CA001,CA004 | | P001 | CA002,CA004 | | P002 | CA003 | | P006 | CA005,CA001 | | P004 | CA005,CA002 | | P007 | CA005,CA002 | | P008 | CA005,CA004 | +--------+--------------------------------+ 8 rows in set (0.00 sec) |