Update a Car in the Repair Shop Database

Repair Shop | Display Cars

Step 1) Select a Customer's Information:

Select a Customer:




The sql for the customer selection
SELECT * from Car WHERE customer_ID=''

Step 2) Select a Car to Update:

Select the Customer's Car:




The sql for the car selection
SELECT * from Car WHERE car_ID=''

Step 3) Update the Car's Information:

Car ID:
Make:
Model:
Year:




The sql for the update
UPDATE Car SET make = '', model = '', car_year = '' WHERE car_ID='';