How to add multiple column and store in different output in MYSQL?

Question

I have 4 column in which i wanna get two sum values for 2-2 column individually

I am trying this

   SELECT (SUM (`user1`) + SUM(`user2`)),(SUM (`customer1`) + SUM(`customer2`)) 
   AS (`totalUsers`,`totalCustomers`) FROM `collection`

it was working for

  SELECT SUM (`user1`) + SUM(`user2`) AS `totalUsers` FROM `collection`

I was giving result

 RowDataPacket { totalUsers: 3345 }

So I thought of doing that in similar fashion,but it is not working for multiple sum result.It is giving

Unhandled rejection Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS totalUsers FROM collection' at line 1

How do i achieve this?

Madhur Bhaiya · Accepted Answer · 2018-10-28 07:27:42Z

1

You need to define aliases individually for an expression/column.

SELECT (SUM (`user1`) + SUM(`user2`)) AS `totalUsers`,
       (SUM (`customer1`) + SUM(`customer2`)) AS `totalCustomers`
FROM `collection`

answered Oct 28, 2018 at 7:27

Madhur Bhaiya

28.9k10 gold badges53 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

How to add multiple column and store in different output in MYSQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related