/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 vote221 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote211 views1 answer
Netstat -tln mysql
SQL
0 vote192 views1 answer
Get number of table colums in sql query
SQL
0 vote247 views1 answer
Select 1 from orders
SQL
0 vote210 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote194 views1 answer
List column names of multiple tables psql
SQL
0 vote214 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote304 views1 answer
Sqlite woth cmake
SQL
1 vote228 views1 answer
Minus vs intersect in sql
SQL
7 votes202 views1 answer
Mysql remote connection command line
SQL