/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 vote198 views1 answer
When mysql server would not work in xampp
SQL
11 votes174 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote184 views1 answer
How to access to mysql without root
SQL
0 vote176 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote158 views1 answer
Sql server cannot create database diagram
SQL
0 vote169 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote128 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote172 views1 answer
Postgres 11 add primary key
SQL
1 vote175 views1 answer
How to check the mysql version mac
SQL
0 vote170 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL