SQLite中的自增關(guān)鍵字：AUTO_INCREMENT、INTEGER PRIMARY KEY與AUTOINCREMENT

SQLite不支持關(guān)鍵字AUTO_INCREMENT

AUTO_INCREMENT不生效的問(wèn)題

在SQLite中，自增字段需要使用關(guān)鍵字INTEGER PRIMARY KEY

buffer.append("CREATE TABLE userIntegralDetail (_id INTEGER PRIMARY KEY,")
.append("userid char(32),")
.append("Num char(11),")
.append("Type char(11),")
.append("timestamp char(13))");
db.execSQL(buffer.toString());