z247 wrote:
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

Read the error message.

You don't have "super" privilege for your mysql user.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to