Error On Startup: Android.database.sqlite.sqliteexception: Near ")": Syntax Error: Create Table Table1(id Integer Primary Key, Name Text));

When I start up my app, I get 02-05 18:50:14.943: ERROR/AndroidRuntime(328): Caused by: android.database.sqlite.SQLiteException: near ')': syntax error: CREATE TABLE table1(id INTE

Solution 1:

In your create table statement you have an extra ')'

Try:

db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY, name TEXT);");

Solution 2:

db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY, name TEXT);");

is what you want. you have one to many closing brackets.