Jay wrote:
You really should not rely on implicit assumptions in your code, such as 'the first value of an autoincrement field is 1'. If you use a different database, or different version of this one, that may be wrong and a nightmare to fix.
There are calls that will return the value of the field after it's inserted, you should use them instead.
--- Andrew Shakinovsky <[EMAIL PROTECTED]> wrote:
Will the default value of an INTEGER PRIMARY KEY column always start at 1? Example: CREATE TABLE xyz (id INTEGER PRIMARY KEY); INSERT INTO xyz VALUES (NULL);
Will the value of the id column always be 1 in this example? I tried numerous tests, and it seems to always start at 1, I wanted to just make sure this would always be the case before I start relying on it in my code.
Or you could start by inserting a 1.
Ulrik P.
-- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark
