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

2004-08-22 Thread Martijn Tonies
> 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

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

2004-08-20 Thread 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 implemente

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

2004-08-20 Thread Joshua Beall
MySQL 4.0.20-standard, but willing to upgrade if I have to -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Calculated fields - is there any way to do this?

2004-08-20 Thread Joshua Beall
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 direc