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 votes289 views1 answer
Rename stored procedure in sql server
SQL
0 vote239 views1 answer
Generate sequence number in sql server
SQL
2 votes253 views1 answer
Sql count having
SQL
0 vote269 views1 answer
How to add session data into mysql database from button
SQL
10 votes256 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote251 views1 answer
Linked server delete openquery
SQL
2 votes272 views1 answer
How to delete columns in sql
SQL
3 votes270 views1 answer
Oracle sleep
SQL
1 vote255 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote246 views1 answer
Postgresql conectar
SQL