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. mysql> (select * from order_db);| orderid custid | itemcode | orderquantity2 |2 |22 I111 |250200222100800600| deliverydate| modeofpayment | date_of_order || 2020-05-302020-05-302021-09-21 | R| C| C2020-05-282020-05-281998-02-153 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 1mysql> update order_db-> SET deliverydate = DATEADD(day, 5, order_db.date_of_order);ERROR 1305 (42000): FUNCTION sp_cs355.DATEADD does not existmysql> update order_db-> set deliverydate = date_of_order + 5;ERROR 1292 (22007): Incorrect date value: '20200533' for column 'deliverydate' at row 1mysql>

The task is to update the delivery dates within a database table called "order_db". Specifically, we…

Answered: Change the delivery date in the table…

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

See similar textbooks

Related questions

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.

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

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions