更新和删除数据

更新数据

UPDATE Customers
SET cust_email = 'Kim@thetoystore.com'
WHERE cust_id = '10000005';

 

删除数据

DELETE FROM Customers
WHERE cust_id = '100000006';