Update a car in the Automobile Body Repair Shop Project
Select a Customer to retrive cars:
----------
Joe Johnson
Bob Robertson
Mary Sue
Olaf Olafsson
Christopher Christophson
Patrick Smith
Dave Tucker
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
111
101
Nissan
Rogue
2010
112
102
Nissan
Ultima
2010
113
103
Toyota
Camry
2010
114
104
Toyota
Rav4
2010
115
105
Chevy
Cruze
2010
116
106
Chevy
Malibu
2010
117
107
Jeep
Renegade
2015
1212
1212
Ford
F150
2015
Back to the Repair Shop main menu