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 vote370 views1 answer
Oracle for loop on list
SQL
4 votes375 views4 answers
Date less than in sql
SQL
0 vote333 views1 answer
How to increase the width of the screen in oracle
SQL
-2 votes346 views1 answer
Modify column name in tsql
SQL
10 votes330 views1 answer
How to import database in mysql by cmd
SQL
13 votes554 views4 answers
Sql joining 3 tables
SQL
2 votes372 views1 answer
Oracle sql merge
SQL
0 vote350 views1 answer
Load utilities in sql server
SQL
1 vote349 views1 answer
Mysql sort by date column
SQL
20 votes396 views6 answers
Change password in mysql
SQL