/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

0 vote142 views1 answer
Do postgresql
SQL
0 vote146 views1 answer
MySQL error code 2068
SQL
0 vote151 views2 answers
Alter table add multiple columns mysql
SQL
0 vote167 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote149 views1 answer
Sql alternative to max statement
SQL
2 votes154 views1 answer
Datetrunc
SQL
1 vote156 views1 answer
Decalre temp table sql
SQL
1 vote166 views1 answer
Sql server kill all connections
SQL
-1 vote161 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote98 views1 answer
Oracle sql developer script output limit
SQL