> 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
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
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]
Hi,
> SELECT product, price * 1.22 AS price_with_vat
> WHERE price_with_vat < 1000;
mysql> select price * 1.22 as pricevat from pricelist;
+--+
| pricevat |
+--+
|12.81 |
+--+
1 row in set (0.02 sec)
mysql> select price * 1.22 as pricevat from pricelist having pricev
On Fri, Jan 25, 2002 at 01:06:12PM +1030, Graham wrote:
> I have looked at the documentation and have been unable to locate any
> information in respect of calculated fields.
> Can anyone verify the lack of this feature in mysql or point me to the area
> of the documentation which discusses
> them
In the last episode (Jan 25), Graham said:
> I have looked at the documentation and have been unable to locate any
> information in respect of calculated fields. Can anyone verify the
> lack of this feature in mysql or point me to the area of the
> documentation which discusses them if the are ind
