mysql count some column's values in one column

Question

I have that MySQL table:

table
| ID | col1 | col2 | col 3|
  1      1      0      1
  2      0      1      1
  3      1      1      1

how to count all col1, col2, col3 in one column to each row like this?

table
| ID | colnew |
  1      2      
  2      2    
  3      3

Thx.

Do you want the count or the sum? Your example is ambiguous, all columns have 1 and you do not clarify why. — Erwin Brandstetter
– Erwin Brandstetter, Commented Jun 2, 2012 at 22:16

eggyal · Accepted Answer · 2012-06-01 09:28:22Z

5

SELECT ID, col1 + col2 + col3 AS colnew FROM my_table

answered Jun 1, 2012 at 9:28

eggyal

127k18 gold badges220 silver badges244 bronze badges

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

1 Answer 1