1UPDATE employees
2SET
3 email = 'mary.patterson@classicmodelcars.com'
4WHERE
5 employeeNumber = 1056;Code language: SQL (Structured Query Language) (sql)
1UPDATE employees
2SET
3 lastname = 'Hill',
4 email = 'mary.hill@classicmodelcars.com'
5WHERE
6 employeeNumber = 1056;Code language: SQL (Structured Query Language) (sql)