mysql@lists.mysql.com
Sent: Tuesday, December 27, 2005 4:34 PM
Subject: Need Help Writing a Trigger
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
PROTECTED]
To: MySQL List mysql@lists.mysql.com
Sent: Tuesday, December 27, 2005 4:34 PM
Subject: Need Help Writing a Trigger
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
,
Jesse
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Jesse [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Wednesday, December 28, 2005 10:20 AM
Subject: Re: Need Help Writing a Trigger
Jesse,
Therefore, instead of putting that long calculation in my query
]
To: Jesse [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Wednesday, December 28, 2005 10:20 AM
Subject: Re: Need Help Writing a Trigger
Jesse,
Therefore, instead of putting that long calculation in my query every
time,
I'm looking for a simpler solution, a more automatic one
]
To: Jesse [EMAIL PROTECTED]
Cc: MySQL List mysql@lists.mysql.com
Sent: Wednesday, December 28, 2005 1:48 PM
Subject: Re: Need Help Writing a Trigger
Jesse,
BTW, is there a way to change this function so that it does away with the
today variable, and uses a field from a different database? For
instance
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
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