From: Dan Nelson
Date: August 22 2010 12:14am
Subject: Re: Performing subtraction between fields
List-Archive: http://lists.mysql.com/mysql/222637
Message-Id: <20100822001418.GC73221@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Aug 21), Ashish Mukherjee said:
> Well, since you are searching that column, it's probably a good idea.
> 
> Possible scenarios for not storing computed values -
> 
> 1)  Data integrity - say, the columns A and B are updated but C does not get
> updated, resulting in an anomalous situation

You could use a trigger that updates C whenever A or B changes, to make sure
it stays in synch.

-- 
	Dan Nelson
	dnelson@stripped