CREATE TABLE speakalarm2([ID] INTEGER PRIMARY KEY,[IDCardNo] VARCHAR (50),[info] TEXT,[CreatedTime] TimeStamp NOT NULL DEFAULT (datetime('now','localtime')));
INSERT INTO speakalarm2([IDCardNo],[info]) VALUES('eeed','出入门37号非法进入报警');
SELECT info,CreatedTime from speakalarm2 where CreatedTime > '2020-10-05 14:48:50' and CreatedTime< '2020-10-05 14:51:00'
info CreatedTime
出入门20非法进入报警 2020-10-05 14:50:33
出入门20非法进入报警 2020-10-05 14:50:42
SELECT info,CreatedTime from speakalarm2
info CreatedTime
出入门4非法进入报警 2020-10-05 14:48:32
出入门20非法进入报警 2020-10-05 14:50:33
出入门20非法进入报警 2020-10-05 14:50:42
出入门56非法进入报警 2020-10-05 14:51:21
出入门68非法进入报警 2020-10-05 14:51:35
出入门37非法进入报警 2020-10-05 14:51:47