/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 vote331 views1 answer
How to convert DateTime to VarChar SQL
SQL
-1 vote353 views1 answer
Partial search in sql
SQL
1 vote342 views1 answer
Oracle duration between timestamps
SQL
0 vote304 views1 answer
Mysql earlier than date
SQL
18 votes337 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote343 views1 answer
Mysql query to add hours to column in table
SQL
1 vote326 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote360 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
1 vote372 views1 answer
Base64 encode sql server
SQL
1 vote329 views1 answer
List index mysql cli
SQL