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
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
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]
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
Hello folks!
Does MySQL support calculated fields? Maybe this isn't the right name
(I don't really know the database theory), so let me explain by
example:
CREATE TABLE pricelist (product VARCHAR(255), price DECIMAL(10,2),
price_with_vat = ROUND(price * 1.22, 1));
Now, the column
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 pricevat
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 indeed included.
If they are not available has anyone
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 indeed
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