UPDATE table_name SET column 1 = value 1, column 2 = value 2 ... WHERE…

The idea

This is the pattern for editing data in SQL. Start with the keyword UPDATE and the name of the table whose records you want to change. Then SET gives each column a new value, written as column = value, and several columns can be changed in one statement by separating the assignments with commas. Finally WHERE states the condition that decides which rows are edited, for example WHERE StudentID = 42. So UPDATE Student SET Year = 11, Tutor = '8B' WHERE StudentID = 42 changes two fields of one record. The order matters: table name, then SET assignments, then WHERE. Text values go in single quotation marks; numbers do not. Without WHERE, every row is changed.

What earns the marks

• The statement begins with UPDATE followed by the table name, identifying which table's records are edited.
• SET introduces one or more assignments in the form column = value.
• Multiple columns can be updated in a single statement, with the assignments separated by commas.
• The WHERE clause gives the condition that selects which rows are changed, so only matching records are edited.
• The clauses appear in the order UPDATE table_name, SET assignments, WHERE condition.
• Values are written appropriately: numbers as numerals and text in single quotation marks.

Common mistakes and how to put them right

• Putting WHERE before SET.

  Put it right: The correct order is UPDATE, table name, SET assignments, then WHERE.

• Separating column assignments with the word AND instead of commas.

  Put it right: SET uses commas between assignments.

• Omitting the WHERE clause, which would update every row in the table rather than the intended record.

• Writing the table name after SET or leaving it out.

  Put it right: The table name must directly follow UPDATE.

Exam tips

• Build the statement in the fixed order: UPDATE, table name, SET, assignments, WHERE, condition.
• Use commas between multiple column assignments and check each one has the form column = value.
• Put text values in single quotation marks and leave numeric values unquoted.
• Re-read the WHERE condition to confirm it identifies exactly the record or records the question describes.