How to sum the column values and update in another column using Sqlite-Sqlite Update query
SQL syntax:
UPDATE TABLE_NAME set COL4 = COL1+ COL2 + COL3;
UPDATE STUDENTS set TOTAL = ENGLISH + MATH + SCIENCE;
SQL syntax:
UPDATE TABLE_NAME set COL4 = COL1+ COL2 + COL3;
UPDATE STUDENTS set TOTAL = ENGLISH + MATH + SCIENCE;