/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

3 votes147 views2 answers
Oracle drop sequence
SQL
25 votes127 views5 answers
Date in mysql
SQL
0 vote126 views1 answer
Renommer table sql
SQL
25 votes131 views3 answers
How to use a database to see tables mysql
SQL
1 vote120 views1 answer
Regular expression in sql server
SQL
0 vote144 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote99 views2 answers
Delete the last item in a table sql
SQL
0 vote128 views1 answer
Difference between 2 query results sql server
SQL
0 vote151 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
1 vote128 views2 answers
Mysql: command not found
SQL