/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

2 votes138 views1 answer
Sql to char function with date
SQL
0 vote141 views1 answer
SQL Server format datetime
SQL
2 votes200 views1 answer
Oracle Column Names of a table
SQL
6 votes153 views1 answer
Oracle trigger after logon on schema
SQL
0 vote108 views1 answer
Mysql date + 1 day
SQL
1 vote145 views2 answers
String to date postgres
SQL
2 votes169 views1 answer
Oracle kill session by sql_id
SQL
0 vote160 views1 answer
Oracle calculate statistics on partition
SQL
5 votes161 views6 answers
In operator sql
SQL
0 vote216 views1 answer
Mac os zsh: command not found: mysql
SQL