List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 20 2004 9:10pm
Subject:Re: Calculated fields - is there any way to do this?
View as plain text  
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
Thread
Calculated fields - is there any way to do this?Joshua Beall20 Aug
  • Re: Calculated fields - is there any way to do this?Joshua Beall20 Aug
  • Re: Calculated fields - is there any way to do this?Dan Nelson20 Aug
  • Re: Calculated fields - is there any way to do this?Martijn Tonies22 Aug