SQL UPDATE বিন্যাস

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 one column in a row

We will add 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