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 dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org