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 vote138 views1 answer
Not between mysql
SQL
3 votes160 views1 answer
How to uninstall microsoft sql server
SQL
3 votes147 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote147 views3 answers
Database restoring error
SQL
0 vote150 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote129 views2 answers
Insert into
SQL
0 vote135 views1 answer
Sql server udf performance
SQL
0 vote154 views1 answer
Sql server python connection
SQL
9 votes142 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote143 views1 answer
Dump db only triggers mysql
SQL