王台汽车站 城阳:ASP如何批量删除ACCESS数据库中的内容

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/12 20:49:19
有选择地删,比如删除所有某一键值(非主键)为“1”(或一指定值)的内容。
谢谢!

delete from tbl where fld=key

Delete From [TableName] Where [Item]=1

如果该键为数字型
Delete From [TableName] Where [Item]=1
字符型
Delete From [TableName] Where [Item]=\'1\'