【SQL语法】系列09: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 |
删除所有行
DELETE FROM 表
时间宝贵,只能复制+粘贴,若图片无法显示或排版混乱,请访问https://elesos.github.io查找原文