MySQL Forums
Forum List  »  Newbie

Re: automatically calculated field
Posted by: Barry Galbraith
Date: January 14, 2011 04:39PM

>Is it possible to achieve it in other way

Yes. Like I showed in the previous post.

>While table creating can we set the third field based on some formula at time of creating table it self.

No. Just create a field to hold the value, and calculate the value at INSERT time.

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: automatically calculated field
January 14, 2011 04:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.