SQL初学者教程：掌握SQL DELETE 语句

初学者   教程   掌握   SQL  

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_nameorDELETE * FROM table_name

本文地址：http://www.cg3000.com/html/cgTutorials/Website/SQL/20070705/SQLchuxuezhejiaocheng_zhangwoSQL_DELETE_yuju_14095.shtml