Question: Write and execute the MySQL code that will create the ADD _ ORDER _ LINE trigger. Whenever a record is added to the Forder _

Write and execute the MySQL code that will create the ADD_ORDER_LINE trigger. Whenever a record is added to the Forder_Line table, add the NUM_ORDERED value of the inserted record to the ON_ORDER value in the Fpart table.
Execute the trigger by adding the following record:
INSERT INTO FORDER_LINE
VALUES
('21617','CD52',20,3600.00);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!