3 ms·
SQLite does support auto-incrementing: https://www.sqlite.org/autoinc.html https://www.sqlite.org/autoinc.html. Is your gripe with the lack of "GENERATED BY DEF
by dmux 3y ago
SQLite does support auto-incrementing: https://www.sqlite.org/autoinc.html https://www.sqlite.org/autoinc.html. Is your gripe with the lack of "GENERATED BY DEFAULT AS IDENTITY" syntax specifically?
- jchw 3y agoYes, sorry. My gripe is that we don't have a single general way to say "I don't really care about the specifics, I just want a number that goes roughly upward" for all database engines. SQLite is interesting in that it supports at least two distinct sets of semantics for auto-incrementing rows, but neither of them are the standard syntax...
- richardwhiuk 3y agoThe gripe is that there's not a standard say of defining this in SQL. SQLite SQL != MySQL SQL != ISO SQL