Display order_id, customer_id from order_db whose month of delivery is the current month.
Display order_id, customer_id from order_db whose month of delivery is the current month.
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...
Related questions
Question
100%
The class I'm taking is databass management in computer science!
I have attached the problem below! Please view both attachments before answering. one attachment is the table and its contents and the other attachment is the question i need help finding a solution for. I am using mysql terminal. Please explain in detail so i can fully understand . Thank you so much in advance!
Transcribed Image Text:mysql> alter table order_db drop column status;
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show create table order_db;
| Table | Create Table
| order_db | CREATE TABLE 'order_db' (
`orderid` int DEFAULT NULL,
'custid` int DEFAULT NULL,
'itemcode ` int DEFAULT NULL,
`orderquantity' int DEFAULT NULL,
`deliverydate`date DEFAULT NULL,
`modeofpayment` char(1) DEFAULT NULL,
`date_of_order' date DEFAULT NULL,
UNIQUE KEY `uc_order_id` (`orderid`),
KEY `fk_customer' ('custid`),
CONSTRAINT `fk_customer' FOREIGN KEY (`custid`) REFERENCES `customer_db` (`cust_id`),
CONSTRAINT `chk_mode_of_payment` CHECK ((`modeofpayment` in (_utf8mb4'D', _utf8mb4'R',_utf8mb4'C')))
> ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
1 row in set (0.00 sec)
‒‒‒‒‒‒‒‒‒‒‒‒
Transcribed Image Text:Display order_id, customer_id from order_db whose month of delivery is the
current month.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
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.Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning