MySQL函數(shù)GROUP_CONCAT

關(guān)于mysql函數(shù)GROUP_CONCAT

GROUP_CONCAT()是MySQL數(shù)據(jù)庫(kù)提供的一個(gè)函數(shù)，通常跟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;

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]