How does one add or subtract two fields in a select statement

[John]

I would like to subtract tow fields in table
for example Table1 has fields A, B, C

I wrote the statement as follows

Select A, B, (A-B) as diff from Table1.

MySQL is complaining that there is a syntax error near '-'

thank you
John

[Aggro]

John wrote:

I would like to subtract tow fields in table
for example Table1 has fields A, B, C

I wrote the statement as follows

Select A, B, (A-B) as diff from Table1.

MySQL is complaining that there is a syntax error near '-'

mysql> create table Table1(A int, B int);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into Table1 values(4,2),(13 ,4),(8,6);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select A, B, (A-B) as diff from Table1;
+------+------+------+
| A | B | diff |
+------+------+------+
| 4 | 2 | 2 |
| 13 | 4 | 9 |
| 8 | 6 | 2 |
+------+------+------+
3 rows in set (0.00 sec)

mysql> select Version();
+-------------+
| Version() |
+-------------+
| 3.23.49-log |
+-------------+
1 row in set (0.02 sec)

mysql>

[Aggro]

John wrote:

I would like to subtract tow fields in table
for example Table1 has fields A, B, C

I wrote the statement as follows

Select A, B, (A-B) as diff from Table1.

MySQL is complaining that there is a syntax error near '-'

mysql> create table Table1(A int, B int);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into Table1 values(4,2),(13 ,4),(8,6);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select A, B, (A-B) as diff from Table1;
+------+------+------+
| A | B | diff |
+------+------+------+
| 4 | 2 | 2 |
| 13 | 4 | 9 |
| 8 | 6 | 2 |
+------+------+------+
3 rows in set (0.00 sec)

mysql> select Version();
+-------------+
| Version() |
+-------------+
| 3.23.49-log |
+-------------+
1 row in set (0.02 sec)

mysql>

[Aggro]

John wrote:

I would like to subtract tow fields in table
for example Table1 has fields A, B, C

I wrote the statement as follows

Select A, B, (A-B) as diff from Table1.

MySQL is complaining that there is a syntax error near '-'

mysql> create table Table1(A int, B int);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into Table1 values(4,2),(13 ,4),(8,6);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0

mysql> select A, B, (A-B) as diff from Table1;
+------+------+------+
| A | B | diff |
+------+------+------+
| 4 | 2 | 2 |
| 13 | 4 | 9 |
| 8 | 6 | 2 |
+------+------+------+
3 rows in set (0.00 sec)

mysql> select Version();
+-------------+
| Version() |
+-------------+
| 3.23.49-log |
+-------------+
1 row in set (0.02 sec)

mysql>