Re: MySql 5 replacement for computed default column value

[Harald Fuchs]

In article <43B99C1E.8080401@stripped>,
Daniel Kasak <dkasak@stripped> writes:

> 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.

If SELECT performance is good enough, a VIEW would probably be easier.