总也记不住的update语法>_< sql update set

 

The Update Statement Update 声明

The UPDATE statement is used to modify the data in a table.
UPDATE 声明可用来更新数据表中的数据

语法

UPDATE table_nameSET column_name = new_value WHERE column_name = some_value

---

Person:

LastNameFirstNameAddressCityNilsenFredKirkegt 56StavangerRasmussen Storgt 67 

---

Update one Column in a Row
更新记录行中的一个栏目

We want to add a first name to the person with a last name of "Rasmussen":
我们将给person表中LastName为"Rasmussen"的数据添加一个first name值

UPDATE Person SET FirstName = 'Nina'WHERE LastName = 'Rasmussen'

结果:

LastNameFirstNameAddressCityNilsenFredKirkegt 56StavangerRasmussenNinaStorgt 67 

---

Update several Columns in a Row
给一记录行更新多个栏目

We want to change the address and add the name of the city:
我们将个人信息中Lastname为"Rasmussen"的所在城市名和地址做一次改变：

UPDATE PersonSET Address = 'Stien 12', City = 'Stavanger'WHERE LastName = 'Rasmussen'

结果:

LastNameFirstNameAddressCityNilsenFredKirkegt 56StavangerRasmussenNinaStien 12Stavanger