Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Calculated Field MYSQL

claculated field in mysql database



3:19 pm on Aug 2, 2011 (gmt 0)

10+ Year Member

Is it possible to put a calculation as a field in a mysql database. For example if I wanted column3 to be the sum of the values of column 1 and column 2, is that possible?

Is there a syntax for doing that kind of thing in a mysql record?


1:09 pm on Aug 18, 2011 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

Not that I am aware. But the bigger question is why would you want to do such a thing? It is redundant data since it can be calculated at any given time during data retrieval.

Featured Threads

Hot Threads This Week

Hot Threads This Month