Help with mysql triggers

2007-02-12 Thread Winn Johnston
Question. I have two tables donation_test, and max_donation. The max donation table is a summary table, used to keep the max donation for each contact_id, by listing its donation_id. We have decided to use database level triggers to keep the summary table (max_donation) table up to date. I have bee

Re: MySQL Triggers

2005-07-28 Thread Gleb Paharenko
Hello. I'm able to insert a record with a trigger to another table at least at 5.0.10. May be these lines from ChangeLog shows new behavior: "It is no longer necessary to issue an explicit LOCK TABLES for any tables accessed by a trigger prior to executing any statements that might invok

MySQL Triggers

2005-07-28 Thread Fredrick Bartlett
Am I reading the documentation correctly. I cannot us a trigger to insert a record into an other table??? I use triggers on other dbms to create an acivity histoy table. Fredrick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.