SQLite is supposed to autoincrement by default when a column is defined as "INTEGER PRIMARY KEY" according to everything I've read. But I've only gotten this to work if I let SQLite create its own PK column. If I have an explicit PK column, I am expected to specify an ID myself. What am I missing? I don't know why I'm getting this error. Thanks.
CREATE TABLE test1 (name TEXT, date DATE); INSERT INTO test1 VALUES ('Barney', 1999 ); SELECT * FROM test1; name date ---------- ---------- Barney 1999 SELECT *, rowid FROM test1; name date rowid ---------- ---------- ---------- Barney 1999 1 CREATE TABLE test2 ( id INTEGER PRIMARY KEY, book text, page INTEGER ); INSERT INTO test2 VALUES ( 'Fletch', 245 ); Error: table test2 has 3 columns but 2 values were supplied INSERT INTO test2 VALUES ( 1, 'Dragnet', 17 ); SELECT *, rowid FROM test2; id book page id ---------- ---------- ---------- ---------- 1 Dragnet 17 1 INSERT INTO test2 VALUES ( 'Lord of the Rings', 327 ); Error: table test2 has 3 columns but 2 values were supplied INSERT INTO test2 VALUES ( 9, 'Lord of the Rings', 327 ); SELECT *, rowid FROM test2; id book page id ---------- ---------- ---------- ---------- 1 Dragnet 17 1 9 Lord of th 327 9 -- _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users