Re: Calculated fields - is there any way to do this?

[Dan Nelson]

In the last episode (Aug 20), Joshua Beall said:
> Is there any way in MySQL to have calculated fields?  E.g., a make
> "expiration" equal to the "lastPaid" date, plus 1 year.  Whenever
> lastPaid gets updated, expiration can be updated as well.
> 
> Is this possible?  I know it could be implemented client side, but I
> am wondering if it could be done directly in MySQL?

Not until views (will be in 5.0) or triggers (targeted for 5.1) are
implemented.

-- 
	Dan Nelson
	dnelson@stripped