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

1 vote214 views1 answer
Mysql monthname
SQL
3 votes133 views1 answer
Sql is not like
SQL
0 vote177 views1 answer
Updating database in sql
SQL
0 vote133 views1 answer
How to print some string in mysql
SQL
0 vote132 views1 answer
Jdbc sql connection string
SQL
16 votes116 views1 answer
Mysql reset auto increment value
SQL
0 vote121 views1 answer
Insert data from stored procedure into table
SQL
2 votes123 views1 answer
Sql update from different table
SQL
0 vote167 views1 answer
Stop and start mysql
SQL
8 votes123 views2 answers
Update sql server from another table
SQL