SQL DELETE 語(yǔ)句
DELETE 語(yǔ)句
DELETE 語(yǔ)句用于刪除表中的行。
語(yǔ)法
DELETE FROM 表名稱(chēng) WHERE 列名稱(chēng) = 值
Person:
| LastName | FirstName | Address | City |
|---|---|---|---|
| Gates | Bill | Xuanwumen 10 | Beijing |
| Wilson | Fred | Zhongshan 23 | Nanjing |
刪除某行
"Fred Wilson" 會(huì)被刪除：
DELETE FROM Person WHERE LastName = 'Wilson'
結(jié)果:
| LastName | FirstName | Address | City |
|---|---|---|---|
| Gates | Bill | Xuanwumen 10 | Beijing |
刪除所有行
可以在不刪除表的情況下刪除所有的行。這意味著表的結(jié)構(gòu)、屬性和索引都是完整的：
DELETE FROM table_name
或者：
DELETE * FROM table_name