CREATE TABLE `student` (
   `id` ) NOT NULL AUTO_INCREMENT,
   `name` ) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE DEFAULT CHARSET=utf8;

 -- ----------------------------
 -- Records of student
 -- ----------------------------
 ', 'tom');
 ', 'jerry');

 CREATE TABLE `course` (
   `id` ) NOT NULL AUTO_INCREMENT,
   `s_id` ) NOT NULL,
   `c_name` ) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE DEFAULT CHARSET=utf8;

 -- ----------------------------
 -- Records of course
 -- ----------------------------
 ', '语文');
 ', '数学');
 ', '英语');
 ', '体育');
 ', '美术');

 SELECT S.`NAME`,(SELECT GROUP_CONCAT(COURSE.C_NAME) FROM COURSE WHERE COURSE.S_ID = S.ID) FROM STUDENT AS S;