Re: [sqlite] delete with an "exists" clause

>I realize your example may not reflect the specific needs of your >application, ... Yea, my actual application required a query too complex to be put in an ordinary "where" clause. I think I've figured it out - think of the "exists" clause as sort of an implied join with the table to be

Re: [sqlite] delete with an "exists" clause

On Thu, 9 Apr 2009, Dave Dyer wrote: > This little program deletes all rows. Is this a bug, or > perhaps I misunderstand how delete with an exists clause > is supposed to work. > > drop table if exists dummy; > create table dummy ( var int); > insert into dummy (var) values (1); > insert into

Re: [sqlite] delete with an "exists" clause

You want: delete from dummy where var=2; In years of DB work, I've never used exists. If you're mentioning this as a bug, I guess it could be: I'd have to lookup exists to see exactly how it's supposed to work. Jim On 4/9/09, Dave Dyer wrote: > > This little