On Fri, Oct 30, 2009 at 9:35 AM, Ted Rolle <ster...@gmail.com> wrote:
> The first field in my table is ID primary integer autoincrement.
First, change the above to
ID INTEGER PRIMARY KEY
> I read that if it is set to NULL it defaults to the maximum value
> possible. Not a Good Thing(tm).
I have no idea where you read that, and what the above means, but look
at the following --
SQLite version 3.6.19
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE foo (a INTEGER PRIMARY KEY, b TEXT);
sqlite> INSERT INTO foo (a, b) VALUES (1, 'blah');
sqlite> INSERT INTO foo (b) VALUES ('more blah');
sqlite> INSERT INTO foo (a, b) VALUES (NULL, 'even more blah');
sqlite> SELECT * FROM foo;
a b
---------- ----------
1 blah
2 more blah
3 even more
sqlite>
I didn't get any "maximum value possible"
>
> How do I let this start out at the default value and auto increment?
> My column separator is '|'.
>
> Ted
>
--
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
-----------------------------------------------------------------------
Assertions are politics; backing up assertions with evidence is science
=======================================================================
Sent from Madison, WI, United States
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
