On 12 Jan 2012, at 10:14am, Durga D wrote: > create table if not exists t0 ( > h integer primary key autoincrement, > t0info text, unique(t0info)); > > t0 table allows duplicate t0info column, when in transaction. > > how to avoid duplicates for t0info column.
If your table was created with that command, then it should not allow duplicate t0info columns. Did you perhaps create it first without the 'unique' requirement, and now your 'CREATE TABLE IF NOT EXISTS' command is doing nothing ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
