我们总结的SQL DELETE 语句
delete 语句delete 语句用于删除表中的行。语法delete from 表名称 where 列名称 = 值
person:
lastname firstname address city
gates bil xuanwumen 10 beijing
wilson fred zhongshan 23 nanjing
删除某行"fred wilson" 会被删除：
delete from person where lastname = 'wilson' 结果astname firstname address city
gates bill xuanwumen 10 beijing
删除所有行可以在不删除表的情况下删除所有的行。这意味着表的结构、属性和索引都是完整的：
delete from table_name或者：
delete * from table_name
转载于：[color=#000000]http://bbs.******.cn/showtopic-12067.aspx[/color]
页:
[1]