T tarunap Active Member 32 2014 1 0 Nov 22, 2014 #1 Hi all, I want the query to take sum of individual row, in Mysql Database. Thanks in advance.
RocketMan Active Member 1,762 2015 415 0 Jan 22, 2015 #2 tarunap said: Hi all, I want the query to take sum of individual row, in Mysql Database. Thanks in advance. Click to expand... select item_1 + item_2 + item_3 + item_4 as ItemSum from MyTable
tarunap said: Hi all, I want the query to take sum of individual row, in Mysql Database. Thanks in advance. Click to expand... select item_1 + item_2 + item_3 + item_4 as ItemSum from MyTable
immu Active Member 2,249 2010 352 430 Jan 23, 2015 #3 ^ Exactly SELECT COLUMN1 + COLUMN2 + COLUMN3 + COLUMN4 + COLUMN5 + .. FROM YOUT_TABLE