/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

4 votes253 views2 answers
Select todays data postgres query
SQL
0 vote268 views1 answer
Mysql_union
SQL
0 vote269 views2 answers
Database owner can't create new tables postgres
SQL
0 vote289 views1 answer
Find how many table doesn't contain column in mysql
SQL
10 votes289 views3 answers
Sql select between two dates
SQL
46 votes333 views4 answers
Create column sql
SQL
-1 vote246 views10 answers
Delete Query in SQL Server
SQL
8 votes290 views2 answers
Phpmyadmin default password
SQL
0 vote282 views1 answer
SQL SELECT-Klausel
SQL
1 vote284 views3 answers
Nth highest salary
SQL