"BEGIN..COMMIT;" fails in SQLite

Question

I'm trying to learn how to use BEGIN ... COMMIT in SQLite. I'm trying this code:

BEGIN
INSERT INTO fields VALUES ('field1')
COMMIT;

but it fails with

Error: near "INSERT": syntax error

When using just the insert statement, it succeeds, though:

INSERT INTO fields VALUES ('field1');

score 7 · Accepted Answer · answered Jun 17 '13 at 13:37

7

Since you have it in a transaction you must end each statement with ;

BEGIN;
INSERT INTO fields VALUES ('field1');
COMMIT;

answered Jun 17 '13 at 13:37

Mad Dog Tannen

1

Ok, then its just because you forgot the ; in the transaction – Mad Dog Tannen Jun 17 '13 at 13:39
I took the example from http://stackoverflow.com/a/5178713/492336, but the example was for MySQL. – sashoalm Jun 17 '13 at 13:40

1 Answers1