Can MySQL cells be equal to an operation between cells?

Can MySQL Cell "ctr" automatically equal "clicks"/"views"

[Jeremy_H]

Can a MySQL table be setup where cells are equal to a calculation between values on the same row?

For example, in excel, you can set CELL A1 =B1/C1

Can you set MySQL CELL CTR =CLICKS/VIEWS

This is the closest I could find on the MySQL website. [dev.mysql.com...]

Thanks

[Slade]

MySQL 5+ supports views, that is what you're really after.

Triggers would also do what you're after, but it appears they don't exist till 5.0.2 either...

So, what version of MySQL are you running?

[Jeremy_H]

Ewww, not good, looks like I run at version 4.0.24.

:(

Lame.

Thanks though, you've been very much of a help. At least I know there are functions like that.