"ed" <[email protected]> wrote in message news:[email protected] > Does 'INSERT INTO mem_db SELECT * FROM file_db' work the same as > 'CREATE TABLE mem_db AS SELECT * FROM file_db' with regard to > transactions? Are the inserts going to be handled as one large > transaction in either scenario?
Yes. > Do I need to explicitly use the BEGIN > and COMMIT commands? You may want to, if you want CREATE TABLE and INSERT to happen together atomically. You don't need to just for INSERT. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
