Hello! В сообщении от Tuesday 06 January 2009 19:29:43 Craig Smith написал(а): > By searching the archives of this list, I was able to come up with > this syntax to identify duplicate records and place a single copy of > each duplicate into another table:
There is simple way: dump your database and add to table talks definition "constraint constraint_ignore_dup unique (member_id, date) on conflict ignore". So after loading this dump dumplicate records will be ignored. see http://www.sqlite.org/lang_conflict.html http://www.sqlite.org/lang_createtable.html Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
