1UPDATE table_name
2SET variable = 'changed field', variable = 'another changed field'
3WHERE firstline_name = 1;
1UPDATE table_name SET field1 = 'value 1', field2 = 'value 2'
2WHERE field3 = 'value 3'
3
1UPDATE tableName SET columnName = yourValue;
2#to update multiple columns:
3UPDATE tableName SET column1 = value1, column2 = value2; #and so on
1-- Set New Employee Password
2UPDATE employee
3SET employee.password = '1234'
4WHERE employee.email = 'emp@gmail.com';
1UPDATE tableName SET anAttribute = 'Something' WHERE anOtherAttribute = 'SomethingElse'
2
3//All 'SomethingElse' values will become 'Something'
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)