Update a customer in the Automobile Body Repair Shop Project
SELECT * from Customer WHERE customer_ID=''
The sql for the insert
UPDATE Customer SET
fName = '',
lName = '',
addr = '',
phone = ''
WHERE customer_ID='';
Customer ID |
First Name |
Last Name |
Address |
Phone Number |
101 | Joe | Johnson | 42 Wullaby Way | 8675309 |
102 | Bob | Robertson | 86 East Point | 3333333 |
103 | Mary | Sue | 124 Conch St | 5111111 |
104 | Olaf | Olafsson | 344 South Fairview | 4512257 |
105 | Christopher | Christophson | 555 Sandwich Dr | 8888888 |
106 | Patrick | Smith | 100 Rainbow Rd | 7418529 |
1212 | Dave | Tucker | 123 Maple St. | 111223333 |
Back to the Repair Shop main menu