On Apr 16, 2012, at 11:47 AM, Patrik Nilsson wrote: > You can use: > > create table t ( id integer primary key autoincrement, created_on > DATETIME DEFAULT CURRENT_TIMESTAMP ) > >
No, the above will create a PK on only the 'id' column. I want a composite PK with 'id' and 'created_on' columns, but 'autoincrement' keyword seems to work only with 'primary key' invocation. > > On 04/16/2012 06:27 PM, Mr. Puneet Kishor wrote: >> Given >> >> CREATE TABLE t ( >> id INTEGER NOT NULL, >> created_on DATETIME DEFAULT CURRENT_TIMESTAMP >> PRIMARY KEY (id, created_on) >> ); >> >> how can I make just the 'id' column auto-increment? >> >> >> -- >> Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users