M
N
D
auto_increment in D1 doesn't work
M
auto_increment is not valid and is ignored.D
Kauto_increment is the wrong spelling. It should be AUTOINCREMENT, and is only valid on a INTEGER PRIMARY KEY column.INTEGER PRIMARY KEY will become an alias for the rowid column by default, it usually isn't needed.D
DDKDDDD
K
JALTER TABLE statement in SQLite.JCREATE TABLE my_table2, copy all my_table. data to my_table2, and then renaming it to my_table)K
ZDD
CC
DDDDDDDDDDD
GCDDC
auto_incrementauto_incrementauto_incrementAUTOINCREMENTINTEGER PRIMARY KEYINTEGER PRIMARY KEYrowidALTER TABLECREATE TABLE my_table2my_tablemy_tablemy_table2