MySQL select sum as given column

Question

Lets say I have a Table with 3 columns

|aaa | bbb | ccc|
|---------------|
|111 | 123 | uuu|
|333 | 234 | uuu|
|555 | 345 | nnn|

Now I select a sum like:

SELECT *, sum(bbb) as bbb from myTable GROUP BY ccc

I recive

|aaa | bbb | ccc | bbb|
|---------------------|
|333 | 234 | uuu | 357|
|555 | 345 | nnn | 345|

bbb is set new in output...

Is there a way to replace the column that exists so I get:

|aaa | bbb | ccc |
|----------------|
|333 | 357 | uuu |
|555 | 345 | nnn |

I know I could use an other name but using an other name is not the question :)

just do as select aaa,sum(bbb) as bbb,ccc from myTable GROUP BY ccc — Abhik Chakraborty
– Abhik Chakraborty, Commented Mar 4, 2015 at 12:57
Just modify the query to select the columns that you want. But, you have a malformed group by, with a column in the select that is not in the group by. — Gordon Linoff
– Gordon Linoff, Commented Mar 4, 2015 at 12:57
the thing is there are about 25 columns... and typing everycolumn is kind of... annoing since I dont know if there will be some columns added in future ^^ — Dwza
– Dwza, Commented Mar 4, 2015 at 12:58

Jens · Accepted Answer · 2015-03-04 12:57:08Z

3

You have to add all columns you need to the select clause:

SELECT aaa, sum(bbb) as bbb,ccc from myTable GROUP BY ccc

answered Mar 4, 2015 at 12:57

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

5 Comments

Dwza Over a year ago

the thing is there are about 25 columns... and typing everycolumn is kind of... annoing since I dont know if there will be some columns added in future ^^

Jens Over a year ago

There is no other way :(

Dwza Over a year ago

Also no way to select all fields except one ?

Dwza Over a year ago

Ok, ill accept this one as soons as i'm allowed :) thx anyways.

stwalkerster Over a year ago

It's probably better to mention each column in the query anyway, then changes in the underlying database structure don't affect your application, allowing updates of the database structure before you roll out a new version of your application, reducing the amount of time your application is unusable.

stwalkerster · Accepted Answer · 2015-03-04 12:57:21Z

3

Don't include that column in the SELECT part of the query.

SELECT aaa, sum(bbb) as bbb, ccc from myTable GROUP BY ccc;

answered Mar 4, 2015 at 12:57

stwalkerster

1,8671 gold badge23 silver badges32 bronze badges

1 Comment

Dwza Over a year ago

1up because you were 20sec later than the other poster, otherwise I had accepted this one.

Collectives™ on Stack Overflow

MySQL select sum as given column

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related