Welcome to WebmasterWorld Guest from 54.211.136.250

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)

5+ 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.