Re: [sqlite] ADD UNIQUE CONSTRAINT

Thank you, I was wondering about adding a new constraint to an existing column that is currently holding data. On Sun, Oct 10, 2010 at 10:54 AM, P Kishor wrote: > On Sun, Oct 10, 2010 at 2:45 AM, Fadhel Al-Hashim > wrote: > > Good day, > > > > is it possible to Alter

[sqlite] ADD UNIQUE CONSTRAINT

Good day, is it possible to Alter a table and add a unique constraint on one or more columns? thanks, fadhel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Delete from A what is not in B

yes PRIMARY KEY (x,y,z) On Sat, Oct 2, 2010 at 9:10 PM, Simon Slavin wrote: > > On 2 Oct 2010, at 1:15pm, Fadhel Al-Hashim wrote: > > > I did not add indices on those columns assuming that being PK is enough? > is > > that right? > > How did you define the primary

Re: [sqlite] Delete from A what is not in B

I did not add indices on those columns assuming that being PK is enough? is that right? On Sat, Oct 2, 2010 at 3:08 PM, Drake Wilson wrote: > Quoth Fadhel Al-Hashim , on 2010-10-02 14:51:59 +0300: > > tryingA.x<>B.xANDA.y<>B.y ANDA.z<>B.z w

[sqlite] Delete from A what is not in B

Good day everyone. I have two tables that contain about 5 million records. I am trying to write an SQL command to delete rows from table A with PK (x,y,z) where PK (x,y,z) is not in table B. tried using "NOT IN" but my PK is composite. tryingA.x<>B.xANDA.y<>B.y ANDA.z<>B.z