Answer 1

CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount; Query OK, 0 rows affected (0.01 sec)
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html