Re: trying to combine rows

[douglas wilson]

You can use the Group_Concat command for combine two rows.It can easily combine the rows.

I will put some example here,

SELECT student_name, GROUP_CONCAT(test_score) FROM student GROUP BY student_name;

First of all you must create the Student table with student name and test_score after that insert the values in to the table using insert into statement.