I'm trying to find out what the limit is with INTEGER PRIMARY KEY.
The documentation says. ".INTEGER PRIMARY KEY columns can be used to implement the equivalent of AUTOINCREMENT. If you try to insert a NULL into an INTEGER PRIMARY KEY column, the column will actually be filled with a integer that is one greater than the largest key already in the table. Or if the largest key is 2147483647, then the column will be filled with a random integer But what is the theoretical limit for the integer, and if it is filled with a random integer, would this be a signed integer or an unsigned integer? Thanks in advance Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: <http://www.mybowlingdiary.com/> http://www.mybowlingdiary.com Email: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
