AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY - android

You need to add a space between KEY_ID AND INTEGER

So change

+ KEY_ID + "INTEGER PRIMARY KEY AUTOINCREMENT, "

+ KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "

android sqlite auto-increment

Create table with integer primary key no need to explicitly mention the AUTOINCREMENT

e.g.

CREATE TABLE t1(  a INTEGER PRIMARY KEY,  C TEXT); Insert into t1(C) values("Hello");

android sqlite auto-increment

Create Table like this put some space before INTEGER ....

"CREATE TABLE "+TABLE_NAME+" ("+KEY_ID+" INTEGER PRIMARY KEY AUTOINCREMENT)";

CodeHunter