删除某行

"Nina Rasmussen"会被删除：

DELETE FROM Person WHERE LastName = 'Rasmussen' 

结果:

删除所有行

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

DELETE FROM table_name or DELETE * FROM table_name

Head photo Go homepage Upload pictures Write articles	SQL初学者教程：掌握SQL DELETE 语句_[SQL Server教程] DELETE 语句 DELETE 语句用于删除表中的行。 语法 DELETE FROM table_nameWHERE column_name = some_value Person:	LastName	FirstName	Address	City	LastName	FirstName	Address	City