CODEWITHSUNDEEP
databasephpmyadmin
Stumpp
Stumpp

Reputation: 289

phpmyadmin - Sum all columns into one column

I have a database with a lot of columns with different values.

enter image description here

Is it possible to add the sum of all the columns into one column single column? So 200+ columns will become one column

Upvotes: 0

Views: 3368

Answers (1)

j0chn
j0chn

Reputation: 1113

If I see it correctly this is a table and no database and than this are rows and not coloumns.
So if the screenshot you posted is everything you have, it is simply: 

SELECT SUM(<ColoumnTitle>) As <newColoumnTitle>
FROM <TableName>;

If this is not the only table, I need more information.

Upvotes: 2

Related Questions