/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

1 vote132 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote143 views2 answers
Sql query for getting details by id
SQL
7 votes149 views3 answers
Foreign key oracle
SQL
0 vote150 views1 answer
How to check which table has data in mysql
SQL
0 vote105 views1 answer
Create duplicate table postgres
SQL
3 votes136 views1 answer
Oracle undo tablespace list by user
SQL
0 vote144 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote184 views2 answers
SQL BULK INSERT
SQL
3 votes142 views2 answers
Check data in table mysql
SQL
2 votes123 views1 answer
Mysql auto increment jumping
SQL