Hello friends,


I'm brand new to this SQL and I'm trying to create a database to keep statistics, where some fields are fixed values entered manually and some others are automatically filled from calculations on the previous ones. As much as an Excel spreadsheet, where some columns are calculated fields defined by formulas. I actually don't know even if is this possible in a MySQL database, and I'll appreciate any help to achieve this or an authorized opinion who makes me leave this idea and look for another alternative. I'm managing the database not from the shell but thru PHPMyAdmin, but I haven't found an implementation for what I want.

Thanks in advance for your help.

Reguards
Nikhil