Update a Customer in the Repair Shop Database

Repair Shop | Display Customers

Step 1) Select a Customer to Update:

Customer Name:



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

Step 2) Update the Customer's Information:

Customer ID:
First Name:
Last Name:
Email Address:
Phone Number:




The sql for the update
UPDATE Customer SET last_name = '', first_name = '', address = '', phone = '' WHERE customer_ID='';