SQL初学者教程:掌握SQL DELETE 语句_[SQL Server教程]
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