Welcome to WebmasterWorld Guest from 54.242.173.65

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:12537
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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members