UPDATE statement is used to modify the existing records in a table.
1UPDATE table_name
2SET column1 = value1, column2 = value2, ...
3WHERE condition;
INFO
WHERE condition is important for UPDATE statement because it specifies which record(s) that should be updated. If you omit the WHERE clause, all records will be updated!
Sample Database
| Id | FullName | Title | Department | Manager |
|---|---|---|---|---|
| 1 | Eric Brown | Software Engineer | IT | Frank Martin |
| 2 | Brandon Hart | DevOps Engineer | IT | Justin Martin |
| 3 | Connor Langdon | Software Engineer | IT | Lucas Scott |
| 4 | James Murray | Test Automation Engineer | IT | Frank Martin |
| 5 | Leonard Smith | Software Engineer | IT | Frank Roberts |
Examples / Outputs
1UPDATE Engineer
2SET Title = 'Test Automation Engineer'
3WHERE Id = 1;
| Id | FullName | Title | Department | Manager |
|---|---|---|---|---|
| 1 | Eric Brown | Test Automation Engineer |
IT | Frank Martin |
| 2 | Brandon Hart | DevOps Engineer | IT | Justin Martin |
| 3 | Connor Langdon | Software Engineer | IT | Lucas Scott |
| 4 | James Murray | Test Automation Engineer | IT | Frank Martin |
| 5 | Leonard Smith | Software Engineer | IT | Frank Roberts |
1UPDATE Engineer
2SET Department = 'Cybersecurity'
3WHERE Manager = 'Frank Martin';
| Id | FullName | Title | Department | Manager |
|---|---|---|---|---|
| 1 | Eric Brown | Test Automation Engineer | Cybersecurity |
Frank Martin |
| 2 | Brandon Hart | DevOps Engineer | IT | Justin Martin |
| 3 | Connor Langdon | Software Engineer | IT | Lucas Scott |
| 4 | James Murray | Test Automation Engineer | Cybersecurity |
Frank Martin |
| 5 | Leonard Smith | Software Engineer | IT | Frank Roberts |