/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 vote110 views1 answer
Mysql changer nom table
SQL
6 votes139 views5 answers
Oracle list tablespaces
SQL
0 vote109 views1 answer
Get from database the most recent data limit by 5
SQL
2 votes98 views1 answer
Mysql how to store lat,lng
SQL
5 votes103 views1 answer
Alter table add comment oracle
SQL
4 votes98 views1 answer
Oracle table statistics last analyzed
SQL
3 votes113 views3 answers
Raw select laravel
SQL
0 vote105 views1 answer
Narural join
SQL
0 vote100 views1 answer
Test sql query
SQL
0 vote99 views1 answer
Select from column mysql
SQL