Re: Calculation in a mysql column

2004-04-02 Thread Victoria Reznichenko
"Mike R" <[EMAIL PROTECTED]> wrote: > > I am using mysql 4.0.16. > > Is it possible to put a calculation of two other columns as the default > value for a third column? > > Like: > > time = decimal 3,2 > rate = decimal 3,2 > totals = default is time * rate No. Default values must be constant.

Calculation in a mysql column

2004-04-01 Thread Mike R
I am using mysql 4.0.16. Is it possible to put a calculation of two other columns as the default value for a third column? Like: time = decimal 3,2 rate = decimal 3,2 totals = default is time * rate Thanks, -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys