On 29 Mar 2012, at 5:27pm, Joe Bennett <jammer10...@ka3nam.com> wrote:
> No rows meet this criteria... So, I'm looking for a better way to find the > non unique data in the old_table so I can clear this error and insert it > into the new table... Any ideas? Instead of using the plain INSERT ... command you can use the variants INSERT OR IGNORE ... INSERT OR REPLACE ... Which one you use depends on the order you're getting your old data in, and which record you actually want. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users