1UPDATE [LOW_PRIORITY] [IGNORE] table_name
2SET
3 column_name1 = expr1,
4 column_name2 = expr2,
5 ...
6[WHERE
7 condition];
1
2
3
4
5 UPDATE employees
6SET
7 email = 'mary.patterson@classicmodelcars.com'
8WHERE
9 employeeNumber = 1056;Code language: SQL (Structured Query Language) (sql)