MySQL在更新时将一列的值设置为两列的总和

I'm developing a pos application and I thought that I could reduce the amount of code in the program and prevent errors by letting the mysql server do some work for me. What I would like to is MySQL to calculate the value of one column based on the other value added to table.I'm developing a pos application and I thought