神马品牌网华为荣耀6plus回退包:access如何批量删除和查询
来源：百度文库 编辑：神马品牌网 时间：2024/05/06 00:35:36
目前只会批量删除的.而且还是按照日期查询
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 有空告诉你