setting default values on a field as sum of other fields

[Sally Masipa]

hi

is it possible to assign a default value for field as the sum of other fields from the same table As per below


ALTER TABLE `hr`.`Leave` MODIFY COLUMN `Leave_Outstanding` DECIMAL(10,0) DEFAULT 'Leave_Brought_Forward + Current_Leave';

when running this I get an error number 1067;

if not what id the alternate way of doing it? please provide details

thanks in advance



Edited 1 time(s). Last edit at 12/17/2008 02:41AM by Sally Masipa.