On Wed, 2005-02-02 at 15:00 -0500, Ned Batchelder wrote: > I see from the 3.1 release notes that AUTOINCREMENT is now supported as a > keyword on integer columns. But has anything actually changed about the > semantic of auto increment columns? 3.0 had them as INTEGER PRIMARY KEY. >
With just INTEGER PRIMARY KEY, if you delete the largest key in the table then insert a new row with a NULL key, the key that was deleted will get reused. If you add AUTOINCREMENT, keys will never be reused this way. The value inserted will be one more than the largest key that has ever been in the table since the table was first created. -- D. Richard Hipp <[EMAIL PROTECTED]>
