在mysql中总计两列

Question

I want a resultset for this table:

ID  Number_of_posts   Number_of_user
1   100               21
2   23                34

as

   ID  Number_of_posts   Number_of_user   Number_of_posts_AND_Number_of_user
    1   100               21               178
    2   23                34               178
-----------------------------------------------
        123                55

Is it possible to get the sum of two colums as another column/ as output in mysql?

Answer 1

SELECT SUM(Number_of_posts), SUM(Number_of_user) FROM table;