Is this the only option? I get Access denied. CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount;
MySQL said: Documentation #1227 - Access denied; you need the SUPER privilege for this operation This is sample code from mysql site, http://dev.mysql.com/doc/refman/5.1/en/using-triggers.html Thank you -- View this message in context: http://www.nabble.com/Dynamic-link-tf1896489.html#a5188173 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]