摘要:
经验之谈:情况一:没有查询结果select * from t_Records where 1==1 and R_CheckInTime > '2015-7-12 18:47:00' and R_CheckInTime '2015-07-12 18:47:00' and R_CheckInTim... 阅读全文
摘要:
用下面的语句肯定是行不通的,语句不支持truncate table t_Records方法:1.删除表数据delete from t_Records where 1==12.重置自动增长列update sqlite_sequence set seq=0 where name='t_Records' ... 阅读全文