根据每个ID的自定义公式，仅使用1个输入字段更改MySQL价格？

Question

I have a database with some prices in it:

But I want that I can give every id a formula like : [thatnumber] * or / or - or + . = [AndShowThatPrice]

So for a example: I want just to type here a price:

If I type 10 then I want that the formula for the id=0 will be like: 10 * 8 = 80 <<--- Update to that price in MySQL

And so I want to give each id a formula So for id=1 example: 10 + 140 = 150 <<--- Update to that price in MySQL

* I just want to type the total price in one field, like : 10, then from that value the math will be made and the total price will updated in the database *

Answer 1

You would need at least one other field on the table that would contain your math for prices. For instance a field called math that would be +140. The you could do an update statement with one input box