/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 vote342 views1 answer
Postgresql print variable
SQL
1 vote352 views1 answer
Postgres convert exisiting column to text
SQL
1 vote334 views2 answers
Mysql order by date asc null last
SQL
1 vote403 views1 answer
Mysql update inner
SQL
1 vote360 views4 answers
Aggregate function in sql
SQL
0 vote396 views1 answer
Sqlcl format
SQL
2 votes317 views1 answer
Oracle sql drop column if exists
SQL
0 vote353 views1 answer
How convert into in in sql query
SQL
5 votes302 views1 answer
Copy table from one database to another mysql
SQL
1 vote377 views1 answer
Sql headers delphi
SQL