>BEGIN IMMEDIATE; >CREATE TEMPORARY TABLE mytemptable >AS >SELECT <a bunch of columns> > INTO temp.mytemptable > FROM <a bunch of tables> > WHERE <a bunch of conditions>; >SELECT count(*) > FROM temp.mytemptable; >SELECT <the columns by name or use *> > FROM temp.mytemptable; >DROP TABLE temp.mytemptable; >COMMIT or ROLLBACK;
Without the INTO clause of course, as SQLite3 does not support INTO, only CREATE TABLE ... AS ... SELECT ... which is equivalent to SELECT ... INTO _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
