Update a car in the Automobile Body Repair Shop Project


Select a Customer to retrive cars:


Select a Car to update:



SELECT * from Automobile WHERE car_ID=''

Car ID:
Make:
Model:
Year:




The sql for the update
UPDATE Automobile SET make = '', model = '', year = '' WHERE car_ID='';


Car ID Customer ID Make Model Year
111101NissanRogue2010
112102NissanUltima2010
113103ToyotaCamry2010
114104ToyotaRav42010
115105ChevyCruze2010
116106ChevyMalibu2010
117107JeepRenegade2015
12121212FordF1502015


Back to the Repair Shop main menu