/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 vote353 views1 answer
Postgres killing connections on db
SQL
0 vote396 views1 answer
Create table using the clause with as
SQL
0 vote340 views1 answer
T sql less than date
SQL
0 vote345 views1 answer
Sql comand for removing data from table
SQL
1 vote399 views1 answer
Oracle show execution plan
SQL
1 vote362 views1 answer
Group_concat max length mysql
SQL
1 vote335 views1 answer
Column with prefix in sql
SQL
20 votes383 views6 answers
Change password in mysql
SQL
3 votes344 views2 answers
Mysql create database
SQL
2 votes345 views3 answers
Oracle show column of table
SQL