On Sun, Oct 23, 2005 at 09:24:58PM -0700, David M. Cook wrote: > On Sat, Oct 22, 2005 at 12:19:04PM -0700, Mario Gutierrez wrote: > > > CRETE TABLE my_table ( > > id INTEGER PRIMARY KEY, > > ... > > ) > > > > This would meet your criteria, but 'id' is not an autoincremented column. > > Sorry, I don't get it. Why is it not? Also, why would one do that? If I > wanted an non-autoincremented primary key field I'd use INT PRIMARY KEY.
Oops, I didn't realize there was an actual AUTOINCREMENT keyword that specifies a slightly different autoincrement behavior. http://www.sqlite.org/autoinc.html Dave Cook