mysql combining records from one table

Question

I have a single table that uses test# as the primary key. Here is what that table looks like:

Test# Name VerbalScore readingScore    Notes
  1   Bobby  92                       Good job
  2   Bobby                  40       You Suck Bobby

The problem is I want to view and be able to see when there are multiple verbal scores for the same Name (so be able to see if the person took the same test more than once).

I want to have some kind of select statement to get this result from the above table:

1   Bobby   92   40   Good job, You Suck Bobby

Is that possible?

Jerome WAGNER · Accepted Answer · 2012-06-07 23:00:37Z

1

I am not totally sure I understand what you mean by "see when there are multiple verbal scores" but with mysql 5+, try

SELECT
   Name,
   GROUP_CONCAT(VerbalScore),
   GROUP_CONCAT(readingScore),
   GROUP_CONCAT(Notes)
FROM
   myTable
GROUP BY
   Name;

GROUP_CONCAT is a mysql specific grouping function.

answered Jun 7, 2012 at 23:00

Jerome WAGNER

22.6k10 gold badges64 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

mysql combining records from one table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related