subject
Computers and Technology, 10.11.2019 14:31 tra80

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

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 21:00
In this lab, you add a loop and the statements that make up the loop body to a c++ program that is provided. when completed, the program should calculate two totals: the number of left-handed people and the number of right-handed people in your class. your loop should execute until the user enters the character x instead of l for left-handed or r for right-handed. the inputs for this program are as follows: r, r, r, l, l, l, r, l, r, r, l, x variables have been declared for you, and the input and output statements have been written.
Answers: 3
question
Computers and Technology, 22.06.2019 12:40
How do i get the most points, without any effort?
Answers: 2
question
Computers and Technology, 22.06.2019 20:00
Which location-sharing service offers items for users as a gaming component and also allows them to collectively link their check-ins to publish a trip? a. whrrl b. buzzd c. foursquare (this option is wrong i already tried) d. gowalla for plato
Answers: 2
question
Computers and Technology, 23.06.2019 08:30
Based on your knowledge of a good network, describe what you think is a perfect network would be. what kind of information and resources could users share on this network. what would the network administrator do? what kind of communication would be used?
Answers: 1
You know the right answer?
Write a script that creates and calls a stored procedure named test. this procedure should include t...
Questions
question
Mathematics, 25.11.2019 05:31
question
Mathematics, 25.11.2019 05:31
question
Mathematics, 25.11.2019 05:31
Questions on the website: 13722359