Mysql sql row to column

Question

Now I have 2 tables

STUDENT:  

STUDENT_ID |  STUDENT_NAME | COURSE_ID  
1000       |  Anson        |     1  
1001       |  Jnson        |     1  
1002       |  Andy         |     2  
1003       |  Alex         |     3

COURSE:

COUSE_ID  |  COURSE_NAME    
1         |   P5A  
2         |   P5B  
3         |   P5C

Now I would like to produce the result to show the students name in each class

Idea result:

P5A      P5B    P5C
Anson    Andy   Alex
Jason

what should I do, I am using php + mysql to build web system

jspcal · Accepted Answer · 2013-05-26 07:37:06Z

2

select * from course c left join student s on c.course_id = s.course_id
order by c.course_name, c.course_id

Enumerate the result set. Each time course_id changes, start a new section.

answered May 26, 2013 at 7:37

jspcal

52k7 gold badges76 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2278947 Over a year ago

But when I print it out in PHP, how do I each row print P5A, P5B, P5C student corresponding?

Collectives™ on Stack Overflow

Mysql sql row to column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related