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:

Install and use wireshark program ( send back screen shots and other vital information) case project 3-2: decode a tcp segment in a wireshark capture in this chapter, you walked through tcp segment to interpret the data included in its header. in this project, you use wireshark to capture your own http messafes, examine the tcp headers, and practice interpreting the data you'll find there. 1. open wireshark and snap the window to one side of your screen. open a browser and snap that window to the other side of your screen so you can see both windows.