> 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 w
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
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]
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
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
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,
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 whi
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 the
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
Hi there,
i have a similar query regarding calculated fields. i have a table
which stores the 3 test results in a particular subject. i need to find the
average of the best 2 of the tests, i.e for a entry of 46,47,48 i need to
find average of 47 and 48. as of right now i am using a field
10 matches
Mail list logo
