On 9/11/08, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > P Kishor <[EMAIL PROTECTED]> wrote: > > why? Because INTEGER PRIMARY KEY already provides AUTOINCREMENT > > > There's a difference in using INTEGER PRIMARY KEY with and without > AUTOINCREMENT keyword: http://www.sqlite.org/autoinc.html > >
Thanks. Nice to know the "subtle" difference now. Of course, INTEGER PRIMARY KEY does provide auto-increment (just not AUTOINCREMENT) :-) > Igor Tandetnik > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
