Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

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. 1 attachment is the table and my failed work and the other attachment is the question i need help finding a solution for. i tried using different commands and no luck. I am using mysql terminal .Please explain in detail so i can fully understand . Thank you so much in advance!

Change the delivery date in the table order_db as delivery_date = date of order +
5.
expand button
Transcribed Image Text:Change the delivery date in the table order_db as delivery_date = date of order + 5.
mysql> (select * from order_db);
| orderid custid | itemcode | orderquantity
2 |
2 |
2
2 I
111 |
250
200
222
100
800
600
| deliverydate
| modeofpayment | date_of_order |
| 2020-05-30
2020-05-30
2021-09-21 | R
| C
| C
2020-05-28
2020-05-28
1998-02-15
3 rows in set (0.00 sec)
mysql> update order_db
->set deliverydate='delivery_date = date of order +5';
ERROR 1292 (22007): Incorrect date value: 'delivery_date = date of order + 5' for column 'deliverydate' at row 1
mysql> update order_db
-> SET deliverydate = DATEADD(day, 5, order_db.date_of_order);
ERROR 1305 (42000): FUNCTION sp_cs355.DATEADD does not exist
mysql> update order_db
-> set deliverydate = date_of_order + 5;
ERROR 1292 (22007): Incorrect date value: '20200533' for column 'deliverydate' at row 1
mysql>
expand button
Transcribed Image Text:mysql> (select * from order_db); | orderid custid | itemcode | orderquantity 2 | 2 | 2 2 I 111 | 250 200 222 100 800 600 | deliverydate | modeofpayment | date_of_order | | 2020-05-30 2020-05-30 2021-09-21 | R | C | C 2020-05-28 2020-05-28 1998-02-15 3 rows in set (0.00 sec) mysql> update order_db ->set deliverydate='delivery_date = date of order +5'; ERROR 1292 (22007): Incorrect date value: 'delivery_date = date of order + 5' for column 'deliverydate' at row 1 mysql> update order_db -> SET deliverydate = DATEADD(day, 5, order_db.date_of_order); ERROR 1305 (42000): FUNCTION sp_cs355.DATEADD does not exist mysql> update order_db -> set deliverydate = date_of_order + 5; ERROR 1292 (22007): Incorrect date value: '20200533' for column 'deliverydate' at row 1 mysql>
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education