|
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
Navigation:
[Reply to this message]
|