sale_update.sql

UPDATE ecomm.sale s
SET s.buyerid = 11694
    s.qtysold = 3,
    s.pricepaid = 600.00,
    s.commission = 90.00
WHERE s.salesid = 200;