From: Jan Steinman
Date: September 2 2010 10:08pm
Subject: Re: Best method to keep totals
List-Archive: http://lists.mysql.com/mysql/222819
Message-Id: <36DBDB4A-45A1-4EB0-B1D5-B22766FF01EB@Bytesmiths.com>
MIME-Version: 1.0 (Apple Message framework v1081)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

On 2 Sep 10, at 13:58, Jerry Schwartz wrote:

>> From: Jan Steinman [mailto:Jan@stripped]
>>=20
>>> From: "Jerry Schwartz" <jerry@stripped>
>>>=20
>>> IMNSHO, never store dynamic data in a field unless you absolutely =
have to.

...

>> To do something similar in MySQL, I've used views (which is somewhat =
clumsy),
>> but is there a better way?
>>=20
> [JS] Wouldn't the appropriate place for the calculation be...=20
> in a store procedure that they share? That's basically=20
> the same as a calculated field.

I've never played with stored procedures. Can you point me to a =
tutorial? Or should I just Google for it?

----------------

:::: Jan Steinman, EcoReality Co-op ::::