On Mon, Mar 16, 2009 at 8:31 AM, P Kishor <punk.k...@gmail.com> wrote:
> is there a way to have a table start the INTEGER PRIMARY KEY sequence
> at 0 (or some other arbitrary number)?
>
> --
> Puneet Kishor
>
I should have added.. yes, I can do the following
CREATE TABLE foo (a INTEGER PRIMARY KEY, b TEXT);
INSERT INTO foo VALUES (0, 'blah');
but, I want to do
INSERT INTO foo (b) VALUES ('blah');
additionally, are their any gotchas with forcing INTEGER PRIMARY KEY
(hence, the ROWID) to start from 0?
--
Puneet Kishor http://www.punkish.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Carbon Model http://carbonmodel.org/
Open Source Geospatial Foundation http://www.osgeo.org/
Sent from: Madison WI United States.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
