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, '10.00', '0.00', null, 4,
'american express', '378282246310005', '04/2013', 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