[Solved] android.database.sqlite.SQLiteException: near “)”: syntax error (code 1): [closed]

by


change your query to this , you’re missing some spaces and also you must remove the last comma from the query

@Override
public void onCreate(SQLiteDatabase db) {
        String query = "CREATE TABLE " +  TABLE_PRODUCTS + "(" +
                COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                COLUMN_PRODUCTNAME + " TEXT, " +
                COLUMN_VENUE + " TEXT, " +
                COLUMN_DATEOFSTART + " TEXT, " +
                COLUMN_DATEOFEND + " TEXT, " +
                DURATION_WORKSHOP + " INTEGER, " +
                COST_WORKSHOP + " INTEGER " +
                 ");" ;
        db.execSQL(query);


 }

1

solved android.database.sqlite.SQLiteException: near “)”: syntax error (code 1): [closed]