Hi, Can someone please explain why adding the auto_increment term seems to STOP the auto_increment behaviour?
$ sqlite3 SQLite version 3.3.17 Enter ".help" for instructions sqlite> .headers on sqlite> create table abc (id integer auto_increment primary key, value text); sqlite> insert into abc (value) values ('justvalue'); sqlite> insert into abc (id,value) values (null,'withid'); sqlite> select * from abc; id|value |justvalue |withid sqlite> create table def (id integer primary key, value text); sqlite> insert into def (value) values ('justvalue'); sqlite> insert into def (id,value) values (null,'withid'); sqlite> select * from def; id|value 1|justvalue 2|withid sqlite> Note that abc (the one with auto_increment) does NOT fill in the id primary key. Baffling to anyone except for me? thanks Paul ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------