I have a table named table_1. In which I have columns col_1, col_2, col_3, col_4 and total. I now insert a row with values for col_1, col_2, col_3 and col_4 as Test, 1, Hello and 2 respectively. I want that the sum of col_2 and col_4 is automatically stored in total column of the same row.
If later the values of col_2 or col_4 or both columns is changed then the value in total column should automatically get updated.
Kindly let me know if anything else is required.
Thanks in advance.