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 from B ,then insert the row into table A > immediately, repeat the precess.
Usually strategy 2. Falls back to 1 if A and B are the same table, or if there are triggers that imply inserting rows into B may modify A. Dan. > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users