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