Computers and Technology
Computers and Technology, 06.08.2019 17:10, kam110800

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

answer
Answers: 3

Similar questions

Do you know the correct answer?
Write a script that creates and calls a stored procedure named test. this procedure should include t...

Questions in other subjects:

Konu
Mathematics, 26.01.2021 21:20
Konu
Mathematics, 26.01.2021 21:20