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

5 votes168 views1 answer
Oracle ORA-00054 origin
SQL
6 votes193 views2 answers
Insert into select mysql
SQL
0 vote169 views1 answer
ORA-13717
SQL
0 vote173 views1 answer
Mysql make date from 2 column
SQL
0 vote174 views1 answer
Sql query for displaying age from oldest to youngest
SQL
5 votes242 views4 answers
Restart the psql server windows
SQL
0 vote175 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote164 views1 answer
Sql create text column limited values
SQL
8 votes180 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote163 views1 answer
Sql tabelle erstellen
SQL