http://www.sqlite.org/autoinc.html
try INTEGER PRIMARY KEY (no interger :-)
Best regards, Witold
----- Original Message ----- From: "alok" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, April 04, 2005 12:21 PM
Subject: [sqlite] How to create Auto Increment Field in SQlite
I am knocking my head on door for doing this I try to create table with this feature
Create table min1(slno interger auto_increment,name char(100));
but table doesn't create.
any help or link relate to this is very helpful
Thanks Alok Gupta
