On 27/12/2014 12:13 AM, Teg wrote:
Because AUTOINCREMENT keyword changes the behavior of the ROWID
selection algorithm, AUTOINCREMENT is not allowed on WITHOUT ROWID
tables or on any table column other than INTEGER PRIMARY KEY. Any
attempt to use AUTOINCREMENT on a WITHOUT ROWID table or on a
Hello General,
I was going to say I thought the docs were ambiguous but, on my 3rd
reading I see they aren't. Still, I think this statement could be
re-written to reduce confusion (at least mine).
https://www.sqlite.org/autoinc.html
>>Because AUTOINCREMENT keyword changes the behavior
2 matches
Mail list logo