How to insert row into MySQL table with SUM of certain values

Question

I have a table that looks like so

ACCOUNT AMOUNT
Income  59
Income  69
Income  99
Income  45
COGS    43
COGS    34
COGS    45
Expense 44
Expense 55

I want to insert a row into this table that will have the ACCOUNT value=Gross Profit and the AMOUNT Value = SUM(Income and COGS)

Possible duplicate of http://stackoverflow.com/questions/2843969/insert-new-row-with-data-computed-from-other-rows. Also check out http://stackoverflow.com/questions/6006636/mysql-how-to-create-column-that-automatically-sums-rows — Mark Manning, Jan 29 '16 at 17:15

score 2 · Answer 1 · answered Jan 29 '16 at 17:33

2

Query

INSERT INTO tblName(ACCOUNT, AMOUNT) 
SELECT 'Gross Profit',
SUM(AMOUNT)
FROM tblName
WHERE ACCOUNT IN ('Income', 'COGS');

answered Jan 29 '16 at 17:33

Ullas

1 Answers1