iOS FDMB删除重复的内容

@"CREATE TABLE IF NOT EXISTS snapshot(id INTEGER PRIMARY KEY AUTOINCREMENT, dev_uid TEXT, file_path TEXT, time REAL)"

创建表  snapshot

表中原数据：

1 FFKUAT5MR3R9Y191 20160719162325.JPG 20160719162325

2 FFKUAT5MR3R9Y191 20160719162325.JPG 20160719162325

3 FFKUAT5MR3R9Y191 20160719162325.JPG 20160719162325

4 FFKUAT5MR3R9Y191 20160719173251.JPG 20160719173251

删除后的数据

1 FFKUAT5MR3R9Y191 20160719162325.JPG 20160719162325

4 FFKUAT5MR3R9Y191 20160719173251.JPG 20160719173251

if (database != NULL) {

            NSString *sql = @"delete from snapshot where exists(select * from snapshot s where file_path=snapshot.file_path and s.id<snapshot.id)";

            

            if (![database executeUpdate: sql]) {

                NSLog(@"Fail to delete snapshot to database.");

            } else {

                NSLog(@"成功  ====  ");

            }

        }