Welcome to WebmasterWorld Guest from 54.144.107.83

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)

New User

10+ Year Member

joined:Oct 8, 2005
posts: 36
votes: 0


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)

Administrator

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

joined:July 31, 2003
posts:12533
votes: 0


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.