/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 votes322 views1 answer
Oracle apex warning message
SQL
0 vote360 views1 answer
Create synonym for dblink in oracle
SQL
0 vote317 views1 answer
Truncate table sql server foreign key
SQL
57 votes528 views6 answers
Sql alter table
SQL
4 votes400 views2 answers
Delete all table oracle
SQL
2 votes307 views2 answers
Mysql all columns
SQL
0 vote361 views1 answer
Postgresql list extensions
SQL
0 vote412 views1 answer
How to check common records in 2 table
SQL
0 vote336 views1 answer
Const pool = mysql.createpool()
SQL
10 votes321 views2 answers
Reset mysql root password mac
SQL