Question

Date has been postponed for 5 days. Write a query to change the schedueled date to new date in the scheduled table

Answer 1

Answer: The query to change the schedueled date to new date in the scheduled table in sql is:

First update the sql table

UPDATE tablename

SET `your field name` = DATE_ ADD(`your field name` , INTERVAL 5 DAY)

WHERE Id = value;

Update scheduled set `scheduled date`= DATE_ ADD (`schedueled date`, INTERVAL 5 DAY)

SET Column_ Name = 'YYYY- MM-

DD'

WHERE Id = value

Date = date +5

SET EndDate = '2019-07-26'