Delete 语句
Delete 语句用于删除表中的行。
语法
Delete FROM 表名称 Where 列名称 = 值
Person:
LastName
|
FirstName
|
Address
|
City
|
Gates
|
Bill
|
Xuanwumen 10
|
Beijing
|
Wilson
|
Fred
|
Zhongshan 23
|
Nanjing
|
删除某行
"Fred Wilson" 会被删除:
Delete FROM Person Where LastName = 'Wilson'
结果:
LastName
|
FirstName
|
Address
|
City
|
Gates
|
Bill
|
Xuanwumen 10
|
Beijing
|
删除所有行
可以在不删除表的情况下删除所有的行。这意味着表的结构、属性和索引都是完整的:
或者: