"ed" <epdm...@gmail.com> wrote in message news:d92e64410905221111n431d4434gee6a286aa4b8d...@mail.gmail.com > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
