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
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
