Re: Syntax for UPDATING a table with result of an Aggregate (GROUP BY) Inner Join Function

[Peter Brawley]

Sprocs are more limited in mysql than in other vendors' sql implementations, so the rule for them in mysql might be, an sproc if necessary but not necessarily an sproc.

Denormalised result tables are often necessary for reporting aggregate results, and for OLTP queries generally.

Views don't optimise very well in MySQL, but they're useful esp. for the sort of aggregation we were discussing, ie displaying sums for groups of rows.