查人人中国名人网led视频鼓:access如何批量删除和查询
来源：百度文库 编辑：查人人中国名人网 时间：2024/04/29 16:08:22
目前只会批量删除的.而且还是按照日期查询
DELETE *
FROM iodata
WHERE iodate between #2004-12-25# and #2005-06-01#;
我想知道的是除了用between #2004-12-25# and #2005-06-01#;还可以用什么?
如果我想作用在IOStatus表怎么操作,此表内都是文本记录..有"进入""外出"等....
DELETE *
FROM iodata
WHERE iodate between #2004-12-25# and #2005-06-01#;
我想知道的是除了用between #2004-12-25# and #2005-06-01#;还可以用什么?
如果我想作用在IOStatus表怎么操作,此表内都是文本记录..有"进入""外出"等....
DELETE * FROM iodata
就都删了
还可以用
DELETE *
FROM iodata
WHERE iodate in(#2004-12-25#,......,#2005-06-01#;)
DELETE *
FROM iodata
WHERE iodate >=#2004-12-25# and iodate <= #2005-06-01#
另外表的名字最好不要和字段的名字一样，否则很容易混淆或出错
QQ 214588310 有空告诉你