List:General Discussion« Previous MessageNext Message »
From:Daniel Kasak Date:January 2 2006 9:33pm
Subject:Re: MySql 5 replacement for computed default column value
View as plain text  
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
Thread
MySql 5 replacement for computed default column valueBryan Cantwell2 Jan
  • Re: MySql 5 replacement for computed default column valueDaniel Kasak2 Jan
  • Re: MySql 5 replacement for computed default column valueHarald Fuchs3 Jan
    • Re: MySql 5 replacement for computed default column valueDaniel Kasak3 Jan