Write a script that creates and calls a stored procedure named test. This procedure should include these statements coded as a transaction: INSERT INTO orders VALUES (DEFAULT, 3, NOW(), '10.00', '0.00', NULL, 4, 'American Express', '378282246310005', '04/2016', 4); SELECT LAST_INSERT_ID() INTO order_id; INSERT INTO order_items VALUES (DEFAULT, order_id, 6, '415.00', '161.85', 1); INSERT INTO order_items VALUES (DEFAULT, order_id, 1, '699.00', '209.70', 1); Here, the LAST_INSERT_ID function is used to get the order ID value that's automatically generated when the first INSERT statement inserts an order. If these statements execute successfully, commit the changes. Otherwise, roll back the changes.
Retrieving the Data From the Database:
To write the command that inserts the order to the database, you need to include a statement. If the statement is executed, use commit, and if the statement is not executed, then roll back the automatically generated changes to its original state.
Answer and Explanation:
This is the script that will create and call a stored procedure:
CREATE PROCEDURE test()
DECLARE sql_error TINYINT DEFAULT FALSE;
See full answer below.
Become a member and unlock all Study Answers
Try it risk-free for 30 daysTry it risk-free
Ask a question
Our experts can answer your tough homework and study questions.Ask a question Ask a question
Learn more about this topic:
from Relational Databases TutorialChapter 2 / Lesson 3