MySQL, Can you get the sum of two columns in the same row?

[Violent770]

I have two columns in my table with numeric values. The table has over 1000 rows. I want to add the two number together per row. Do I need to set a varible?

[Darnok]

Nope...try this...
select sum(field_A + field_B) from table_name

[ladyluck]

You will want to alias the result so you can display it:

SELECT value1, value2, SUM(value1, value2) AS totalvalue FROM yourtable

Sample output:
============|===========|==================
value1 |value2 |totalvalue
============|===========|==================
5 |6 |11
10 |2 |12
4 |1 |5
9 |302 |311
===========================================
4 rows returned
===========================================