Update a Customer in the Autobody Repair Shop database


Select a Customer to update:

SELECT * FROM Customer WHERE customer_ID = ''
Customer ID:

First Name:

Last Name:

Address:

Phone:



The sql for the update
UPDATE Customer SET lName = '', fName = '', addr = '', phone = '' WHERE customer_ID = '';





back