Introduction to Programming

UPDATE-statement

The data can be changed by the UPDATE-statement:

UPDATE table_name SET column1=value1,column2=value2,... WHERE-clause;

We have used such a statement to change the first name in one of the records from the original value John to a new value, Jim:

update person set first_name = 'Jim' where last_name = 'Adams'

Later, using the SELECT-statement, we will prove that the change was successful. Without the WHERE-clause, all the records of the table would be affected.