subject

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: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 18:00
Martha is a healer, a healthcare provider, and an experienced nurse. she wants to share her daily experiences, as well as her 12 years of work knowledge, with people who may be interested in health and healing. which mode of internet communication can martha use?
Answers: 3
question
Computers and Technology, 24.06.2019 09:50
Suppose you are an ad-serving company and you maintain a log of cookie data for ads you serve to the web pages for a particular vendor (say amazon). a. how can you use this data to determine which are the best ads? b. how can you use this data to determine which are the best ad formats? c. how could you records of past ads and ad clicks to determine which ads to send to a given ip address? d. how could you use this data to determine how well the technique you used in your answer to part c was working? e. how could you use this data to determine that a given ip address is used by more than one person? f. how does having this data give you a competitive advantage vis-à-vis other ad-serving companies?
Answers: 2
question
Computers and Technology, 24.06.2019 13:00
George heard about the benefits of a data warehouse. he wants to try implementing one for his organization. however, he is afraid that transferring data to the data warehouse will affect transaction time. which element ensures that transactions are not affected when moving data to a warehouse? when data is transferred to a data warehouse, the a area frees the source system to continue transaction processing.
Answers: 2
question
Computers and Technology, 25.06.2019 02:30
On the pie chart below, which “slice” represents 30% of the budget?
Answers: 2
You know the right answer?
Write a script that creates and calls a stored procedure named test. this procedure should include t...
Questions
question
Chemistry, 23.01.2020 00:31
Questions on the website: 13722367