mysql sum, with row IDs

Question

In MySQL I'm trying to sum up a column but retain the row IDs. When I do a sum, the IDs are compressed and the result is

1 | 1500

What I would like is

1,2,3 | 1500

is their any problem if sum repeated no. of times the rows exists. — Punit, Oct 18 '11 at 05:53

Michael Mior · Accepted Answer · 2011-10-18T05:56:24.740

4

SELECT GROUP_CONCAT(id), SUM(value) FROM table

edited Oct 18 '11 at 05:56

answered Oct 18 '11 at 05:46

Michael Mior

Thanks. I had to use `GROUP_CONCAT(CAST(id AS CHAR))` or else I get a BLOB in the result... – lee Oct 18 '11 at 06:00
Glad this worked for you. Out of curiosity, what data type is your `id` column? – Michael Mior Oct 18 '11 at 06:21

Shakti Singh · Answer 2 · 2011-10-18T06:03:50.953

1

SELECT GROUP_CONCAT(id), SUM(column_name) FROM table_name GROUP BY id

edited Oct 18 '11 at 06:03

answered Oct 18 '11 at 05:46

Shakti Singh

I'm getting a [BLOB - 5B] under the GROUP_CONCAT column. Found from http://stackoverflow.com/questions/2133936/using-group-concat-in-phpmyadmin-will-show-the-result-as-blob-3b that GROUP_CONCAT expects value to be a string. Any issues with using `GROUP_CONCAT(CAST(id AS CHAR))` ? – lee Oct 18 '11 at 05:57

2 Answers2