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

0 vote151 views1 answer
Tsql cte in a transaction
SQL
10 votes106 views4 answers
Primary key in sql
SQL
0 vote113 views1 answer
Vowels in sql
SQL
0 vote122 views1 answer
Get server date mysql
SQL
2 votes121 views1 answer
Oracle table size
SQL
6 votes103 views3 answers
Mysql server is not starting xampp
SQL
1 vote114 views1 answer
Pl sql ptint
SQL
4 votes106 views4 answers
Rollback in sql
SQL
0 vote120 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote121 views1 answer
Sql get missing id
SQL