On Tuesday 27 December 2005 2:34 pm, Jesse wrote: > I'm trying to write a trigger that will update the age of a camper when > ever a record is updated or inserted. I have a table named Campers which > contains basic information about the camper as well as their birthday. I > have another table named Config which holds various settings, including the > date at which camp begins. The Age field in the Campers table needs to be > set based on the Config.CampStartDate. So, I have the following query that > does what I need: >
It seems to me that you're storing redundant data. If you know their birthday, than you know their age, just subtract the birthday from today's date and you have it. -- Dr. Joseph Dolan: Isn't there a children's book about an elephant named Babar? Fletch: I don't know. I don't have any. Dr. Joseph Dolan: No children? Fletch: No, elephant books. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]