/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 vote125 views1 answer
Mysql drop key
SQL
0 vote144 views1 answer
Mysql exception output
SQL
5 votes140 views2 answers
Sql server check port number
SQL
0 vote144 views1 answer
Alter table change default
SQL
0 vote145 views1 answer
How to add mysql to path on termin after installation
SQL
1 vote149 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote119 views1 answer
Get who is hired in month in sql
SQL
0 vote125 views1 answer
How to get data between a last week in mysql
SQL
0 vote128 views2 answers
Sqlite unique
SQL
1 vote128 views1 answer
Create sample data postgresql
SQL