/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 vote188 views1 answer
Add mysql database to power bi web
SQL
0 vote165 views1 answer
Mysql date time string format for marshmellow field schema
SQL
3 votes164 views1 answer
Search for column name in psql
SQL
0 vote186 views1 answer
New rails app with mysql
SQL
-2 votes195 views2 answers
Union all in sql
SQL
3 votes181 views2 answers
Sql server current date without time
SQL
0 vote187 views1 answer
Change database name psql 8
SQL
0 vote185 views1 answer
Utiliser sql ligne de commande
SQL
0 vote176 views1 answer
Mysql join same table multiple times group by
SQL
0 vote173 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL