mysql函数GROUP_CONCAT

lzyfn

于 2012-06-13 11:59:42 发布

阅读量82

点赞数

分类专栏： sql数据库的学习文章标签：数据库

本文链接：https://blog.youkuaiyun.com/lzyfn/article/details/84233501

版权

sql数据库的学习专栏收录该内容

6 篇文章

订阅专栏

关于mysql函数GROUP_CONCAT

GROUP_CONCAT()是MySQL数据库提供的一个函数，通常跟GROUP BY一起用,具体可参考MySQL官方文挡:http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat 。

GROUP_CONCAT( [ DISTINCT ] expr [ ,expr ... ] [ ORDER BY { unsigned_integer | col_name | expr} [ ASC | DESC ] [ ,col_name ...] ] [ SEPARATOR str_val] )

SELECT student_id, GROUP_CONCAT( courses_id) AS courses FROM student_courses WHERE student_id=2 GROUP BY student_id;

"SELECT student_id, GROUP_CONCAT(courses_id) AS courses FROM student_courses WHERE student_id=2 GROUP BY student_id"

SELECT student_id, GROUP_CONCAT( courses_id SEPARATOR '|||' ) AS courses FROM student_courses WHERE student_id=2 GROUP BY student_id;

SELECT student_id, GROUP_CONCAT( courses_id ORDER BY courses_id DESC) AS courses FROM student_courses WHERE student_id=2 GROUP BY student_id;