/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

7 votes199 views2 answers
Get database size mysql
SQL
0 vote229 views1 answer
Create table split string function in sql server
SQL
3 votes252 views1 answer
How to uninstall microsoft sql server
SQL
1 vote207 views1 answer
Sql drop schema
SQL
0 vote194 views1 answer
Mariadb cast to int
SQL
0 vote194 views1 answer
Update table sql multiple set
SQL
0 vote205 views1 answer
Mysql query single row
SQL
3 votes197 views1 answer
Create a table with an id in mysql
SQL
8 votes185 views1 answer
How to remove tables from postgresql
SQL
0 vote279 views2 answers
Disadvantages of stored procedures sql
SQL