Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/2/3 6:39:27
SQL初学者教程：掌握SQL DELETE 语句_[SQL Server教程]

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





赞

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)




QQ:154298438
QQ:417480759