Nah, ignore that, I was talking garbage...
Using the view is a neater way of doing that select statement, but you
still need to create the temp table to avoid the locking issues...
Rachel
On 03/12/05, Rachel Willmer <[EMAIL PROTECTED]> wrote:
> (Replying to my own email so I can find this
(Replying to my own email so I can find this answer again via google
in the future...)
I have an even better solution...
CREATE VIEW NewView AS SELECT * FROM table1 LEFT JOIN table2 on
table1.field=table2.field WHERE table2.field is NULL;
Works just fine...
Cheers
Rachel
Back In Oct, I asked:
> Solution 1 is to use a TEMP table:
>
> CREATE TEMP TABLE diffs AS
> SELECT * FROM table1 LEFT JOIN table2 ;
> SELECT * FROM diffs; -- Insert into table1 in the callback;
> DROP TABLE diffs;
that sounds like the answer for me
thanks
Rachel
> I'm not sure I understand your logic. Your left join
> indicates that there are records missing from table2,
> so I would expect that you want to insert the missing
> records into table2. Assuming that's what you meant,
>
> insert into table2
> select * from table1
> where table1.field not
> SELECT * FROM table1 LEFT JOIN table2 on table1.field=table2.field
> WHERE table2.field is NULL
>
> So far, so good, I get the records I want. Then in the callback, I try
>
> INSERT INTO table1 etc...
I'm not sure I understand your logic. Your left join
indicates that there are records missing
Why do it in the call back? Why not just do it in sql:
CREATE TEMP TABLE diffs AS
SELECT * FROM table1 LEFT JOIN table2 ;
insert into table1
SELECT * FROM diffs; -- Insert into table1
DROP TABLE diffs;
On 10/14/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Rachel Willmer <[EMAIL
Rachel Willmer <[EMAIL PROTECTED]> wrote:
> Hi, apologies if this is a trivial question, but I'm a newbie to
> sqlite3. (very impressed so far)
>
> I want to search two tables which should contain the same records and
> add any that are missing from the second into the first.
>
> So I do
>
>
Hi, apologies if this is a trivial question, but I'm a newbie to
sqlite3. (very impressed so far)
I want to search two tables which should contain the same records and
add any that are missing from the second into the first.
So I do
SELECT * FROM table1 LEFT JOIN table2 on
8 matches
Mail list logo