Trigger

mysql> SET @sum = 0;
mysql> INSERT INTO account VALUES(137,14.98),(141,1937.50),(97,-100.00);
mysql> SELECT @sum AS 'Total amount inserted';
+-----------------------+
| Total amount inserted |
+-----------------------+
|               1852.48 |
+-----------------------+

Source: dev.mysql.com

Similar codes

4 votes219 views2 answers
Float postgres
SQL
1 vote206 views1 answer
Sql try catch
SQL
0 vote206 views1 answer
Mysql DDL
SQL
0 vote247 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
5 votes198 views1 answer
Oracle ORA-00054 origin
SQL
1 vote266 views1 answer
Ora-01950 no privileges on tablespace
SQL
1 vote193 views1 answer
How to test for sql injection
SQL
13 votes203 views5 answers
Oracle list tables
SQL
0 vote217 views1 answer
Full outer join in mariadb mysql
SQL
16 votes216 views3 answers
T-SQL Add Column
SQL