Re: [sqlite] about insert into select

On May 21, 2009, at 8:43 AM, Wenton Thomas wrote: > What's the execution sequence about " insert ino A select > from B "? > I means,which is correct prescription in the following: > (1) select all rows from B at first, then insert all the result > into table A; > (2) select a row

Re: [sqlite] about insert into select

On 21/05/2009 11:43 AM, Wenton Thomas wrote: > What's the execution sequence about " insert ino A select from B "? > I means,which is correct prescription in the following: > (1) select all rows from B at first, meanwhile this product (frequently chosen for use on devices with minimal

Re: [sqlite] about insert into select

Wenton Thomas wrote: > What's the execution sequence about " insert ino A select from B "? > I means,which is correct prescription in the following: > (1) select all rows from B at first, then insert all the result into > table A; > (2) select a row from B ,then insert the row into

[sqlite] about insert into select

What's the execution sequence about " insert ino A select from B "? I means,which is correct prescription in the following: (1) select all rows from B at first, then insert all the result into table A; (2) select a row from B ,then insert the row into table A immediately, repeat the