sqlite if not exists应用实例

INSERT or replace INTO  [main].[RecordInfo]([WorkID],[bArtificialAttendance],[fThreshold],[Attendance_Time],[PicPath])
       select ‘012‘,‘1‘,‘60.00‘,‘2015-11-25 11:59:08.000‘,‘123‘ where not exists (SELECT [Attendance_Time] FROM  [main].[RecordInfo] WHERE [WorkID] = ‘012‘  AND [Attendance_Time] = ‘2015-11-25 11:59:08.000‘);