Re: Best method to keep totals

[Jan Steinman]

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

>> From: Jan Steinman [mailto:Jan@stripped]
>> 
>>> From: "Jerry Schwartz" <jerry@stripped>
>>> 
>>> 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?
>> 
> [JS] Wouldn't the appropriate place for the calculation be... 
> in a store procedure that they share? That's basically 
> 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 ::::