Addition in MySQL using information from columns to create a variable?

Question

I have three MySQL columns, Name, Goals, Assists (G and A respectively). I want to calculate points by adding Goals and Assists together, and then sort Names by points.

What I tried was;

$SQL="SELECT * FROM stats WHERE Points=G+A ORDER BY Points";

This didn't work, does anyone have any suggestions on basic addition in MySQL using integers from separate columns?

KethanKumar · Accepted Answer · 2013-11-29 03:01:14Z

1

try this..

$SQL = "SELECT Name, Goals, Assists, (Goals+Assists) AS SumColumn FROM STATUS ORDER BY Points";

answered Nov 29, 2013 at 3:01

KethanKumar

7265 silver badges17 bronze badges

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

Comments

apoq · Accepted Answer · 2013-11-29 03:05:10Z

0

SELECT name, (G+A) AS points FROM stats ORDER BY points

edited Nov 29, 2013 at 3:05

answered Nov 29, 2013 at 2:57

apoq

1,45413 silver badges14 bronze badges

1 Comment

John AJ Over a year ago

Getting syntax errors, 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 'SELECT name, (G+A) AS points ORDER BY points' at line 1

Semi-Friends · Accepted Answer · 2013-11-29 03:13:57Z

0

$SQL="SELECT *, (Goals+Assists) AS totalPoints FROM stats ORDER BY totalPoints";

answered Nov 29, 2013 at 3:13

Semi-Friends

4806 silver badges17 bronze badges

Collectives™ on Stack Overflow

Addition in MySQL using information from columns to create a variable?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related