I have two columns C1 and C2 in a table. I want to store C1+ C2 in C1 for whole table in mysql.

table :-

ID C1 C2
1 20 40
2 30 50
3 40 10
4 50 20

i want the result as:-

ID C1 C2
1 60 40
2 80 50
3 50 10
4 70 20
Anonymous User
Anonymous User
Asked Mar 23, 2016
Edited Mar 23, 2016

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.

Categories