Nilsen

Fred

Kirkegt 56

Stavanger

Rasmussen

Nina

Storgt 67

同样的，用UPDATE语句也可以同时更新多个字段：

UPDATE Person

SET Address = ''''Stien 12'''', City = ''''Stavanger''''

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

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

LastName

FirstName

Address

City

Nilsen

Fred

Kirkegt 56

Stavanger

Rasmussen

Nina

Stien 12

Stavanger

Delete

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