MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: setting default values on a field as sum of other fields
Posted by: Michael McRorey
Date: January 03, 2009 12:34AM

you can't add dynamic values like that. You can however use an on update trigger that will update the Leave_Outstanding with the Leave_Brought_Forward + Current_Leave' values.

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
setting default values on a field as sum of other fields
4790
Sally Masipa
December 17, 2008 02:40AM
Re: setting default values on a field as sum of other fields
2395
Michael McRorey
January 03, 2009 12:34AM


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.