mercredi 2 décembre 2015

Are there implicit autocommit statements in SQLite

I now know that in MySQL there is a long-long list of statements that cause implicit commit, like CREATE, ALTER etc. And I want to know if there is such a thing in SQLite.

In other words I want to know whether, for example, CREATE TABLE and some other constructs cause autocommit and therefore cannot be rollbacked?

I tested it myself and it seems to me, like SQLite behaves like MySQL, but I'm not sure of that and I want to have some reference to the documentation that lists all such commands (I could not find one).

Besides, I want to know if it is possible to tweak some sqlite parameters to prevent it form autocommitting CREATE and other statements.

Aucun commentaire:

Enregistrer un commentaire