UPDATE

update语句用于修改表中的数据。 语法：

UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值

---

更改某一行中的一列 我们为VIN=’GS723HDSAK2399002’的车添加价格： UPDATE CAR SET PRICE = 89000.00 WHERE VIN='GS723HDSAK2399002';

结果:

VINBRANDMODELPRICEPRODUCTION_YEARLJCPCBLCX14500264FordFocus80002005WPOZZZ79ZTS372128FordFusion100002008JF1BR93D7BG498281ToyotaAvensis100001999KLATF08Y1VB363636VolkswagenGolf300019921M8GDM9AXKP042788VolkswagenGolf1000020101HGCM82633A004352VolkswagenJetta600020031G1YZ23J9P5800003FiatPunto60001999GS723HDSAK2399002OpelCorsa89000.002007LP859CCSRH5555963ToyotaAvensis12000.002009LP859CCSRH5555962Toyota12000.00

---

更改某一行中的若干列 我们修改VIN=’LP859CCSRH5555962’列中的BRAND,MODEL,PRICE,PRODUCTION_YEAR. UPDATE CAR SET BRAND='Opel',MODEL='Punto',PRICE=13000.00,PRODUCTION_YEAR='2012' WHERE VIN='LP859CCSRH5555962';

结果：

VINBRANDMODELPRICEPRODUCTION_YEARLJCPCBLCX14500264FordFocus80002005WPOZZZ79ZTS372128FordFusion100002008JF1BR93D7BG498281ToyotaAvensis100001999KLATF08Y1VB363636VolkswagenGolf300019921M8GDM9AXKP042788VolkswagenGolf1000020101HGCM82633A004352VolkswagenJetta600020031G1YZ23J9P5800003FiatPunto60001999GS723HDSAK2399002OpelCorsa89000.002007LP859CCSRH5555963ToyotaAvensis12000.002009LP859CCSRH5555962OpelPunto13000.002012

---