From: Daniel Kasak
Date: January 2 2006 9:33pm
Subject: Re: MySql 5 replacement for computed default column value
List-Archive: http://lists.mysql.com/mysql/193428
Message-Id: <43B99C1E.8080401@nusconsulting.com.au>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Bryan Cantwell wrote:

> Trying to migrate to MySql 5 from Sybase asa. I have a tables that 
> have column values that are calculated based on other columns in the 
> table. How can I accomplish the same in MySql?
>
This sounds a job for a trigger - an insert trigger.
I haven't used triggers in mysql, so I can't help you with exactly how 
to do it.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@stripped
website: http://www.nusconsulting.com.au