You'd have to use another table. I don't believe mysql views will keep your
'moving average' values.
If you're using 5.1, you can automate the select/insert with an event --
it's a cron like tool built into mysql.
If you have a datetime field in either of the tables that represents the
'action'
Anyone here uses OLAP, running in MySQL? Any OpenSOurce OLAP query
tools?
How does one goes about doing OLAP? Is there any documentation w/ MySQL
anywhere. (I'm currently looking at Pentaho and Mondrian etc but the
Pre-configured demo didn't work as it should, meaning it doesn't run for
X reasons)
