Posted by Stefan Rybacki on 10/10/17 11:32

mcyi2mr3@lycos.co.uk wrote:
> hi all!
>
> how do u make a mysql field automtaically become the value of another
> field multiplied by a constant? (without using php if possible)
>
Do you mean permanent? Use a View. If you just need it in a query do something like this:

SELECT *, (field*constant) as calculatedField FROM table

Regards
Stefan

[Back to original message]