How to perform mathematical operations with data in MySql?

Question

PHP

There are 2 tables, each of them has a money line with a certain value, the site has a function for sending points, but when numbers are transferred to the table, it is only added as a new item, I would like them to work according to the laws of mathematics, I listed the points, from your the bills deducted this amount, if they transferred it to you, then naturally they were added, how to implement it?

Answer 1

can you read the documentation a bit?
https://dev.mysql.com/doc/refman/5.5/en/arithmetic...