/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 vote133 views1 answer
Mysql use password error
SQL
8 votes140 views2 answers
Replace string value in sql
SQL
0 vote153 views1 answer
SQL server datetime compare
SQL
5 votes164 views1 answer
Oracle asynchronous query
SQL
0 vote170 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote141 views1 answer
Mysql query single row
SQL
0 vote147 views1 answer
Sqlplus change user
SQL
2 votes162 views1 answer
Sql skip the first row
SQL
5 votes142 views2 answers
Create table mysql example auto_increment
SQL
0 vote169 views1 answer
Connect laravel to mysql on mac
SQL