Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in I_INVOICE_NUM to the date currently found in I_INVOICE_DATE.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

Task 8: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in I_INVOICE_NUM to the date currently found in I_INVOICE_DATE.

INVOICE_NUM
INVOICE_DATE
CUST_ID
14216
2021-11-15
125
14219
2021-11-15
227
14222
2021-11-16
294
14224
2021-11-16
182
14228
2021-11-18
435
14231
2021-11-18
125
14233
2021-11-18
435
14237
2021-11-19
616
Transcribed Image Text:INVOICE_NUM INVOICE_DATE CUST_ID 14216 2021-11-15 125 14219 2021-11-15 227 14222 2021-11-16 294 14224 2021-11-16 182 14228 2021-11-18 435 14231 2021-11-18 125 14233 2021-11-18 435 14237 2021-11-19 616
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Code is incorrect, did not return any results. Screenshot is to prove code doesn't run in mySQL. 

Lab 8-1: KimTay Pet Supplies
Tasks
!!!!
3
Till
CENGAGE MINDTAP
1
Task 8: Create the UPDATE_INVOICE procedure to change the date of the
invoice whose number is stored in I_INVOICE_NUM to the date currently found in
10.00 I_INVOICE_DATE.
0.00
out of
Checks
O out of 1 checks passed. Review the results below for more details.
SQL Database Test Incomplete
Complete task 8
Feedback Ⓡ
The wrong headers were returned.
Some expected rows were missing (shown in red below).
Test Query Ⓡ
CALL UPDATE_INVOICE('00001', '2021-11-21')
SELECT * FROM INVOICES WHERE INVOICE_NUM = '00001'
Expected Results
INVOICE_NUM
00001
Actual Results
No data
INVOICE_DATE
2021-11-21
CUST ID
294
Task 9: Create the DELETE_INVOICE procedure to delete the invoice whose
Lin T THMATAF MLIM
<
E
FILETREE
~/workspace
query.sql
query2.sql
query.sql
1 DELIMITER //
2
3 CREATE PROCEDURE UPDATE_INVOICE (IN I_INVOICE_NUM INT, I_INVOICE_DATE DATE)
4
5 BEGIN
6
7
8
9
10
11 END//
12
13 DELIMITER ;
14
X query2.sql
x +
UPDATE INVOICES SET INVOICE_DATE= I_INVOICE_DATE
SQL Viewer
WHERE INVOICE_NUM=I_INVOICE_NUM;
X >_ Terminal
+
Query completed
Q Search this course
X
?
A-Z
Transcribed Image Text:Lab 8-1: KimTay Pet Supplies Tasks !!!! 3 Till CENGAGE MINDTAP 1 Task 8: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in I_INVOICE_NUM to the date currently found in 10.00 I_INVOICE_DATE. 0.00 out of Checks O out of 1 checks passed. Review the results below for more details. SQL Database Test Incomplete Complete task 8 Feedback Ⓡ The wrong headers were returned. Some expected rows were missing (shown in red below). Test Query Ⓡ CALL UPDATE_INVOICE('00001', '2021-11-21') SELECT * FROM INVOICES WHERE INVOICE_NUM = '00001' Expected Results INVOICE_NUM 00001 Actual Results No data INVOICE_DATE 2021-11-21 CUST ID 294 Task 9: Create the DELETE_INVOICE procedure to delete the invoice whose Lin T THMATAF MLIM < E FILETREE ~/workspace query.sql query2.sql query.sql 1 DELIMITER // 2 3 CREATE PROCEDURE UPDATE_INVOICE (IN I_INVOICE_NUM INT, I_INVOICE_DATE DATE) 4 5 BEGIN 6 7 8 9 10 11 END// 12 13 DELIMITER ; 14 X query2.sql x + UPDATE INVOICES SET INVOICE_DATE= I_INVOICE_DATE SQL Viewer WHERE INVOICE_NUM=I_INVOICE_NUM; X >_ Terminal + Query completed Q Search this course X ? A-Z
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education