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
[email protected]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
