subject

Create a mysql trigger named trg_updatecustbalance to update the cust_balance in the cust_mysql table when a new invoice record is entered. (assume that the sale is a credit sale.) whatever value appears in the inv_amount column of the new invoice should be added to the customer’s balance. test the trigger using the following new inv_mysql record, which would add 225.40 to the balance of customer 2001:

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 01:30
Which tab is used to change the theme of a photo album slide show? a. design b. view c. transitions d. home
Answers: 1
question
Computers and Technology, 24.06.2019 02:30
Which option completes the explanation for conflict of interest in an organization
Answers: 1
question
Computers and Technology, 24.06.2019 07:00
Why would a business likely use a java applet - to back up their data files for the business - to create a program that a customer can launch in their web browser - to create music on a powerpoint presentation - to organize files on their company directory
Answers: 3
question
Computers and Technology, 24.06.2019 16:50
Ramp charts are generally created in wordlotusexcelpowerpoint
Answers: 1
You know the right answer?
Create a mysql trigger named trg_updatecustbalance to update the cust_balance in the cust_mysql tabl...
Questions
Questions on the website: 13722367