/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 vote261 views1 answer
Show indices in mysql table
SQL
1 vote294 views2 answers
Mysql switch case
SQL
0 vote286 views1 answer
Print boolean in plsql
SQL
20 votes298 views6 answers
Change password in mysql
SQL
0 vote263 views1 answer
Mysql installer no packages found
SQL
2 votes255 views2 answers
Function in sql
SQL
6 votes283 views2 answers
If not exists insert sql
SQL
1 vote312 views1 answer
Oracle plan hash value
SQL
5 votes274 views1 answer
Sql check if date is between 2 dates
SQL
0 vote259 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL