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.
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989