Hi All,

I'm creating a database which will look a little like:
create table main (f1 TEXT, f2 TEXT, f3 TEXT, t1 TEXT, t2 TEXT, tn TEXT);

f1, f2 and f3 will always be present. Any or all of the ts might be NULL.

I'd like to prevent entries where all of the fields are the same being
created. How can I do this. I've tried experimenting with UNIQUE KEYs but
haven't been successful - perhaps because of the NULLs?

If this isn't possible my second best option would be a command which
removes existing duplicates.

Thanks a lot for any pointers,
Adam

-- 
Adam Richardson
Carpe Diem

Reply via email to