Hello,
a purely "calculated field" ;(one that is calculated from present values in
the row), doesn' t need to be stored at all, just calculate it when someone
needs to see the calculated value.
In other words.. you don't have to store it if you can calculate it from the
present existing field values in your row.
If it's an historic value, that's a different story,, you would have to
store a running total...
K bye,,
Ken
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 2:45 PM
Subject: Adding fields
>
> Hi All
>
> to many hours anyway I am struggling with what seems to be an easy task
but I am stuck.
>
> I am trying to total the fields with numbers (run + swim + bike) from a
racer name="joe"
> and insert the ammount into a field called totals in a table called
runner.
>
> UPDATE runner SET totals="SUM(run + swim + bike)" WHERE name="joe"
>
>
> Any hints
>
> M;-)
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
