/SQL/Android sqlite add column if not exists

Android sqlite add column if not exists

Cursor cursor = database.rawQuery("SELECT * FROM MY_TABLE", null); // grab cursor for all data
int deleteStateColumnIndex = cursor.getColumnIndex("MISSING_COLUMN");  // see if the column is there
if (deleteStateColumnIndex < 0) { 
    // missing_column not there - add it
    database.execSQL("ALTER TABLE MY_TABLE ADD COLUMN MISSING_COLUMN int null;");
}

Similar codes

1 vote372 views1 answer
Oracle undo usage per session
SQL
0 vote365 views4 answers
How to connect form to database
SQL
4 votes397 views1 answer
Sql delete multiple conditions
SQL
0 vote360 views1 answer
Insert into select with group by
SQL
0 vote369 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote356 views1 answer
Postgres set default schema
SQL
0 vote348 views1 answer
Psql not found windows
SQL
0 vote362 views1 answer
Docker export psql sql
SQL
4 votes359 views5 answers
Primary key
SQL
0 vote434 views1 answer
Python get backup of sql
SQL