insert into max_donations (donation_id, contact_id)
select donation_id, contact_id
from donation_test where conatct_id = (You missppelled contact_id)
NEW.contact_id and total_amount = contact_max_amount;
----- Original Message -----
From: "Winn Johnston" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, February 21, 2007 11:26:42 AM (GMT-0500) Auto-Detected
Subject: trigger
Any way to get this to work inside an after update
trigger?
insert into max_donations (donation_id, contact_id)
select donation_id, contact_id
from donation_test where conatct_id =
NEW.contact_id and total_amount = contact_max_amount;
thanks
winn
____________________________________________________________________________________
Have a burning question?
Go to www.Answers.yahoo.com and get answers from real people who know.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
