SQL UPDATE Statement

UPDATE Statement

The UPDATE statement is used to modify data in the table.

Syntax:

UPDATE table_name SET column_name = new_value WHERE column_name = some_value

Person:

LastName FirstName Address City
Gates Bill Xuanwumen 10 Beijing
Wilson 　 Champs-Elysees 　

Update a column in a row

We add the firstname for people with lastname 'Wilson':

UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'

Result:

LastName FirstName Address City
Gates Bill Xuanwumen 10 Beijing
Wilson Fred Champs-Elysees 　

Update several columns in a row

We will modify the address (address) and add the city name (city):

UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing' WHERE LastName = 'Wilson'

Result:

LastName FirstName Address City
Gates Bill Xuanwumen 10 Beijing
Wilson Fred Zhongshan 23 Nanjing