WHERE column_name = some_value

例：

“Person”表中的原始数据:

LastName

FirstName

Address

City

Nilsen

Fred

Kirkegt 56

Stavanger

Rasmussen

Storgt 67

运行下面的SQL将Person表中LastName字段为”Rasmussen”的FirstName更新为”Nina”：

UPDATE Person SET FirstName = ''''Nina''''

WHERE LastName = ''''Rasmussen''''

更新后”Person”表中的数据为：

LastName

FirstName

Address

City

 << 上一页  [21] [22] [23] [24] [25] [26] [27]  下一页