SQL指南-DELETE语句
DELETE语句
DELETE语句用于删除表中的行。
语法
DELETE FROM table_name WHERE column_name = some_value |
---------------------------------
Person:
LastName | FirstName | Address | City |
---|---|---|---|
Nilsen | Fred | Kirkegt 56 | Stavanger |
Rasmussen | Nina | Stien 12 | Stavanger |
---------------------------------
删除一行
"Nina Rasmussen" 将被删除:
DELETE FROM Person WHERE LastName = 'Rasmussen' |
返回结果
LastName | FirstName | Address | City |
---|---|---|---|
Nilsen | Fred | Kirkegt 56 | Stavanger |
---------------------------------
删除所有行
可能会删除所有行并不删除表。这意味着表的结构属性和索引是完整的。
DELETE FROM table_name or DELETE * FROM table_name |