Chapter 13 Exercise 18

18. Run the three UPDATE and INSERT queries in the text and issue a SELECT statement to see the ending values for the new CustomerID;

Details are in the text, these are the main queries:
INSERT INTO Customer(CustomerID, FirstName, LastName,
ScreenName, Username, Password, Email)
VALUES (469aac21-5600-47c3-882f-f7a1ca269ede, 'Jones', 'Jackie',
'JJJ', 'JJones329', 'password', {'[email protected]'} );
 
UPDATE Customer
SET Password='password2', ScreenName='JJ3'
WHERE CustomerID=469aac21-5600-47c3-882f-f7a1ca269ede;
 
INSERT INTO Customer(CustomerID, Username, Password)
VALUES (469aac21-5600-47c3-882f-f7a1ca269ede, 'JJones329','password');
 
And the final select to verify the data changes:
SELECT *
FROM Customer
WHERE CustomerID=469aac21-5600-47c3-882f-f7a1ca269ede;
Which should show the Password reset to 'password'