DELETE

DELETE语句用于删除表中的行， 语法

DELETE FROM 表名称 WHERE 列名称 = 值

---

CAR表：

VINBRANDMODELPRICEPRODUCTION_YEARLJCPCBLCX14500264FordFocus80002005WPOZZZ79ZTS372128FordFusion100002008JF1BR93D7BG498281ToyotaAvensis100001999KLATF08Y1VB363636VolkswagenGolf300019921M8GDM9AXKP042788VolkswagenGolf1000020101HGCM82633A004352VolkswagenJetta600020031G1YZ23J9P5800003FiatPunto60001999GS723HDSAK2399002OpelCorsa89000.002007LP859CCSRH5555963ToyotaAvensis12000.002009LP859CCSRH5555962OpelPunto13000.002012

---

删除某行 删除VIN=’LP859CCSRH5555962’行: DELETE FROM CAR WHERE VIN='LP859CCSRH5555962'; VINBRANDMODELPRICEPRODUCTION_YEARLJCPCBLCX14500264FordFocus80002005WPOZZZ79ZTS372128FordFusion100002008JF1BR93D7BG498281ToyotaAvensis100001999KLATF08Y1VB363636VolkswagenGolf300019921M8GDM9AXKP042788VolkswagenGolf1000020101HGCM82633A004352VolkswagenJetta600020031G1YZ23J9P5800003FiatPunto60001999GS723HDSAK2399002OpelCorsa89000.002007LP859CCSRH5555963ToyotaAvensis12000.002009

---

删除所有行 可以在不删除表的情况下删除所有行，这意味着表的结构、属性和索引都是完整的。 DELETE FROM CAR

或者

DELETE * FROM CAR

ps:再删除表数据的时候我用（DELETE FROM CAR ）之后我再用(DELETE * FROM CAR)会提示我表明无效，然后我再试了一下上面的（DELETE FROM CAR ）在表没有数据的情况下能够运行，