Question

Due to some reason the bus which is scheduled from Chennai to Bangalore has been postponed for 5 days. what query so i write to change the scheduled date to the new date in the schedule table in sql.

Answer 1

Answer: The answer is like that-

In the schedule table there are attributes : scheduled_id, travel_date, source, destination, bus_no, duration.

For this we need to update the travel_date attribute in the schedule table for the bus which are going to Bangalore.

UPDATE schedule

SET TRAVEL_DATE = '20.4.2019'

WHERE BUS_NO= '123' and DESTINATION= 'Bangalore' and SOURCE= 'Chennai';

Answer 2

Answer:

Explanation:

Due to some error in the information, the bus which was supposed to be scheduled from Chennai to Bangalore has been postponed for five long days, and thus if the passengers who were booked on the bus send a query and request to know about the new schedule, give them the right date. If some passengers want their refund, do the needful.

Please show up with the masses and do the necessary.