DELETE
DELETE语句用于删除表中的行,
语法
DELETE FROM 表名称 WHERE 列名称 = 值
CAR表:
VIN | BRAND | MODEL | PRICE | PRODUCTION_YEAR |
---|---|---|---|---|
LJCPCBLCX14500264 | Ford | Focus | 8000 | 2005 |
WPOZZZ79ZTS372128 | Ford | Fusion | 10000 | 2008 |
JF1BR93D7BG498281 | Toyota | Avensis | 10000 | 1999 |
KLATF08Y1VB363636 | Volkswagen | Golf | 3000 | 1992 |
1M8GDM9AXKP042788 | Volkswagen | Golf | 10000 | 2010 |
1HGCM82633A004352 | Volkswagen | Jetta | 6000 | 2003 |
1G1YZ23J9P5800003 | Fiat | Punto | 6000 | 1999 |
GS723HDSAK2399002 | Opel | Corsa | 89000.00 | 2007 |
LP859CCSRH5555963 | Toyota | Avensis | 12000.00 | 2009 |
LP859CCSRH5555962 | Opel | Punto | 13000.00 | 2012 |
- 删除某行
删除VIN=’LP859CCSRH5555962’行:
DELETE FROM CAR WHERE VIN='LP859CCSRH5555962';
VIN | BRAND | MODEL | PRICE | PRODUCTION_YEAR |
---|---|---|---|---|
LJCPCBLCX14500264 | Ford | Focus | 8000 | 2005 |
WPOZZZ79ZTS372128 | Ford | Fusion | 10000 | 2008 |
JF1BR93D7BG498281 | Toyota | Avensis | 10000 | 1999 |
KLATF08Y1VB363636 | Volkswagen | Golf | 3000 | 1992 |
1M8GDM9AXKP042788 | Volkswagen | Golf | 10000 | 2010 |
1HGCM82633A004352 | Volkswagen | Jetta | 6000 | 2003 |
1G1YZ23J9P5800003 | Fiat | Punto | 6000 | 1999 |
GS723HDSAK2399002 | Opel | Corsa | 89000.00 | 2007 |
LP859CCSRH5555963 | Toyota | Avensis | 12000.00 | 2009 |
- 删除所有行
可以在不删除表的情况下删除所有行,这意味着表的结构、属性和索引都是完整的。
DELETE FROM CAR
或者
DELETE * FROM CAR
ps:再删除表数据的时候我用(DELETE FROM CAR )之后我再用(DELETE * FROM CAR)会提示我表明无效,然后我再试了一下上面的(DELETE FROM CAR )在表没有数据的情况下能够运行,