iOS Question insert in a table of a sqlite db, with primary key autoincrement


Well-Known Member
Licensed User
I created a table with this sqlite command :

CREATE TABLE IF NOT EXISTS table (id integer primary key autoincrement,a TEXT,b TEXT)

When i enter a sqlite command:

INSERT INTO table VALUES('a' 'b')

compiler respond ...

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "'a'": syntax error)

How work the autoincrement ???

Thanks in advice