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 vote183 views1 answer
Like sql for second letter of the family name
SQL
0 vote215 views1 answer
Sql field equals multiple values
SQL
3 votes183 views2 answers
To_char oracle
SQL
-1 vote200 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote185 views1 answer
Sql insert tuple
SQL
0 vote192 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
37 votes200 views3 answers
Duplicate records in sql
SQL
0 vote188 views1 answer
Call procedure in wordpress
SQL
0 vote253 views1 answer
Cannot start database server xampp mac os
SQL
6 votes268 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL