help me plsss

[Anon]

how can i add a column with formula example:
+----+------------+---------+----------+
| id | date | savings | withdraw |
+----+------------+---------+----------+
| 1 | 2002-02-18 | P1,000 | no |
+----+------------+---------+----------+

i will add a column name total_savings then the fromula is: savings-withdraw,how can i do that/,pls s help me.

thank you.

[[deleted]]

Databases don't have 'formula' columns, you should do those calculations in the query, that's what it's for.