Is there a way to create a table in a mysql database that takes data out of a different table in that database performs math on it? I believe that is called a view in oracle and I'm not sure if its supported in mysql.
For example, say I have table A that has 200 rows with 5 columns. I would like to create a table B that selects a collection of records out of table A based on a defined search criteria. Then, I would like table B to sum the values of the columns. In this manner, I could insert new data in table A and correspondingly update table B.
This probably doesn't make any sense....
