blocks|key|719584|text|您可以在onUpgrade()方法上使用ALTER+TABLE函数，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|719585|@Override
public+void+onUpgrade(SQLiteDatabase+db,+int+oldVersion,+int+newVersion)+{
++//+If+you+need+to+add+a+column
++if+(newVersion+>+oldVersion)+{
+++++db.execSQL("ALTER+TABLE+foo+ADD+COLUMN+new_column+INTEGER+DEFAULT+0");
++}
}|code-block|syntax|javascript|719586|显然，根据列定义的不同，SQLite会有所不同。|719587|entityMap^0|4|B|K|B|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

you can use <code>ALTER TABLE</code> function on your <code>onUpgrade()</code> method, like this:

<pre><code>@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 // If you need to add a column
 if (newVersion &gt; oldVersion) {
 db.execSQL("ALTER TABLE foo ADD COLUMN new_column INTEGER DEFAULT 0");
 }
}
</code></pre>

Obviously, the SQLite will differ depending on the column definition.

blocks|key|719607|text|最简单的方法是在SQLiteOpenHelper+class中添加一些SQL+to+the+onUpgrade()方法。类似于：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|719608|@Override
public+void+onUpgrade(SQLiteDatabase+db,+int+oldVersion,+int+newVersion)+{

++++//+If+you+need+to+add+a+new+column
++++if+(newVersion+>+oldVersion)+{
++++++++db.execSQL("ALTER+TABLE+student+ADD+COLUMN+student_rollno+INTEGER+DEFAULT+0");
++++}
}|code-block|syntax|javascript|719609|entityMap^0|8|M|Z|M|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

The easiest way to do this is to add some <code>SQL to the onUpgrade()</code> method in your <code>SQLiteOpenHelper class</code>. Something like:

<pre><code>@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

 // If you need to add a new column
 if (newVersion &gt; oldVersion) {
 db.execSQL("ALTER TABLE student ADD COLUMN student_rollno INTEGER DEFAULT 0");
 }
}
</code></pre>

blocks|key|503584|text|@Aamirkhan.我认为你早就解决了你在评论中提到的问题，我认为你没有增加数据库的版本。我之所以写这篇文章，是因为它可以帮助那些在修改表格时没有增加或更改数据库版本号的人。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|503585|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

@Aamirkhan.i think you would have solved the problem you mentioned in the comments long back ago.i think you didn't increase the data base version. or else the answers here are straight forward.i am writing this because it might help anyone who hasn't increased or changed their data base version number when they are altering a table.

blocks|key|503616|text|当我在自己的应用程序上需要帮助时，我遇到了这个帖子，但我发现许多答案都有问题。我建议您执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|503617|private+static+final+String+DATABASE_ALTER_TEAM_1+=+"ALTER+TABLE+"
++++%2B+TABLE_TEAM+%2B+"+ADD+COLUMN+"+%2B+COLUMN_COACH+%2B+"+string;";

private+static+final+String+DATABASE_ALTER_TEAM_2+=+"ALTER+TABLE+"
++++%2B+TABLE_TEAM+%2B+"+ADD+COLUMN+"+%2B+COLUMN_STADIUM+%2B+"+string;";

@Override
public+void+onUpgrade(SQLiteDatabase+db,+int+oldVersion,+int+newVersion)+{
++++if+(oldVersion+<+2)+{
+++++++++db.execSQL(DATABASE_ALTER_TEAM_1);
++++}
++++if+(oldVersion+<+3)+{
+++++++++db.execSQL(DATABASE_ALTER_TEAM_2);
++++}
}|code-block|syntax|javascript|503618|您希望确保当用户升级一个以上的版本时代码能够正常工作，并且update语句只运行所需的一个升级。有关这方面的更多信息，请查看此blog。|offset|length|503619|entityMap|0|LINK|mutability|MUTABLE|url|https://thebhwgroup.com/blog/how-android-sqlite-onupgrade^0|0|0|1R|4|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

I came across this thread when needing help on my own app, but saw issues with many of the answers. I would recommend doing the following:

<pre><code>private static final String DATABASE_ALTER_TEAM_1 = "ALTER TABLE "
 + TABLE_TEAM + " ADD COLUMN " + COLUMN_COACH + " string;";

private static final String DATABASE_ALTER_TEAM_2 = "ALTER TABLE "
 + TABLE_TEAM + " ADD COLUMN " + COLUMN_STADIUM + " string;";

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 if (oldVersion &lt; 2) {
 db.execSQL(DATABASE_ALTER_TEAM_1);
 }
 if (oldVersion &lt; 3) {
 db.execSQL(DATABASE_ALTER_TEAM_2);
 }
}
</code></pre>

You want to make sure the code will work when users upgrade more than 1 version and that the update statement only runs the one upgrade it is needed. For a bit more on this, check out this <a href="https://thebhwgroup.com/blog/how-android-sqlite-onupgrade" rel="noreferrer">blog</a>.

blocks|key|503678|text|也许一种稍微更优雅的方法是使用switch而不是if/then，它将从任何模式升级到最新的模式...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|503679|下面还有一个关于变更表的语法的不错的页面：http://alvinalexander.com/android/sqlite-alter-table-syntax-examples|offset|length|503680|public+static+final+String+TABLE_TEAM+=+"team";
public+static+final+String+COLUMN_COACH+=+"coach";
public+static+final+String+COLUMN_STADIUM+=+"stadium";


private+static+final+String+DATABASE_ALTER_TEAM_TO_V2+=+"ALTER+TABLE+"
++++%2B+TABLE_TEAM+%2B+"+ADD+COLUMN+"+%2B+COLUMN_COACH+%2B+"+TEXT;";

private+static+final+String+DATABASE_ALTER_TEAM_TO_V3+=+"ALTER+TABLE+"
++++%2B+TABLE_TEAM+%2B+"+ADD+COLUMN+"+%2B+COLUMN_STADIUM+%2B+"+TEXT;";


@Override
public+void+onUpgrade(SQLiteDatabase+db,+int+oldVersion,+int+newVersion)+{

++++switch+(oldVersion)
++++{
++++++++case+1:
++++++++++++//upgrade+from+version+1+to+2
++++++++++++db.execSQL(DATABASE_ALTER_TEAM_TO_V2);
++++++++case+2:
++++++++++++//upgrade+from+version+2+to+3
++++++++++++db.execSQL(DATABASE_ALTER_TEAM_TO_V3);

++++++++//and+so+on..+do+not+add+breaks+so+that+switch+will
++++++++//start+at+oldVersion,+and+run+straight+through+to+the+latest

++++}

}|code-block|syntax|javascript|503681|entityMap|0|LINK|mutability|MUTABLE|url|http://alvinalexander.com/android/sqlite-alter-table-syntax-examples^0|0|L|1W|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@$D|U|E|V|1|W]]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

Perhaps a slightly more elegant approach using switch instead of if/then that will upgrade from any schema to the most recent schema...

Here's also a decent page on the syntax for altering a table: <a href="http://alvinalexander.com/android/sqlite-alter-table-syntax-examples">http://alvinalexander.com/android/sqlite-alter-table-syntax-examples</a>

<pre><code>public static final String TABLE_TEAM = "team";
public static final String COLUMN_COACH = "coach";
public static final String COLUMN_STADIUM = "stadium";


private static final String DATABASE_ALTER_TEAM_TO_V2 = "ALTER TABLE "
 + TABLE_TEAM + " ADD COLUMN " + COLUMN_COACH + " TEXT;";

private static final String DATABASE_ALTER_TEAM_TO_V3 = "ALTER TABLE "
 + TABLE_TEAM + " ADD COLUMN " + COLUMN_STADIUM + " TEXT;";


@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

 switch (oldVersion)
 {
 case 1:
 //upgrade from version 1 to 2
 db.execSQL(DATABASE_ALTER_TEAM_TO_V2);
 case 2:
 //upgrade from version 2 to 3
 db.execSQL(DATABASE_ALTER_TEAM_TO_V3);

 //and so on.. do not add breaks so that switch will
 //start at oldVersion, and run straight through to the latest

 }

}
</code></pre>

blocks|key|719834|text|我认为我们不应该像那样检查状况|type|unstyled|depth|inlineStyleRanges|entityRanges|data|719835|+if+(newVersion+>+oldVersion)+{
+}|code-block|syntax|javascript|719836|因为如果我们使用它，这意味着每次我们增加数据库版本时，onUpdrade()都会调用，条件将为真，所以我们应该像这样检查|719837|if(oldVersion==1)+
{

}|719838|因此，在这种情况下，如果旧版本为2，则条件将为假，并且具有旧版本2的用户将不会更新数据库(用户仅希望版本1)，因为对于这些用户，数据库已经更新。|719839|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I think we should not check condition like that

<pre><code> if (newVersion &gt; oldVersion) {
 }
</code></pre>

because if we use this , it means every time when we increase the database version then onUpdrade() will call and condition will be true , so we should check like that 

<pre><code>if(oldVersion==1) 
{

}
</code></pre>

so in this case if old version is 2 then condition will be false and user with old version 2 will not update the database(which user wants only for version 1), because for those users database had already updated .

blocks|key|503811|text|我在搜索同样的问题时遇到了link。它解释了如何使用upgrade。https://thebhwgroup.com/blog/how-android-sqlite-onupgrade|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|503812|它解释了为什么要使用下面的代码|503813|+@Override
++++public+void+onUpgrade(SQLiteDatabase+db,+int+oldVersion,+int+newVersion)+{
++++++++if+(oldVersion+<+2)+{
+++++++++++++db.execSQL(DATABASE_ALTER_TEAM_1);
++++++++}
++++++++if+(oldVersion+<+3)+{
+++++++++++++db.execSQL(DATABASE_ALTER_TEAM_2);
++++++++}
++++}|code-block|syntax|javascript|503814|entityMap|0|LINK|mutability|MUTABLE|url|https://thebhwgroup.com/blog/how-android-sqlite-onupgrade^0|Y|1L|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

I came across link while searching for the same issue. It explains how to use upgrade. 
<a href="https://thebhwgroup.com/blog/how-android-sqlite-onupgrade" rel="nofollow noreferrer">https://thebhwgroup.com/blog/how-android-sqlite-onupgrade</a>

it explains why to use this below code

<pre><code> @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 if (oldVersion &lt; 2) {
 db.execSQL(DATABASE_ALTER_TEAM_1);
 }
 if (oldVersion &lt; 3) {
 db.execSQL(DATABASE_ALTER_TEAM_2);
 }
 }
</code></pre>

blocks|key|719950|text|在表中创建新列的最简单方法是向SQLiteOpenHelper类中的onUpgrade()方法添加一些SQL。像这样：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|719951|@Override
public+void+onUpgrade(SQLiteDatabase+db,+int+oldVersion,+int+newVersion)+{
++++switch+(oldVersion)+{
++++++++case+1:
++++++++++++db.execSQL(SQL_MY_TABLE);

++++++++case+2:
++++++++++++db.execSQL("ALTER+TABLE+myTable+ADD+COLUMN+myNewColumn+TEXT");
++++}
}|code-block|syntax|javascript|719952|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

The easiest way to create a new column on a table is add some SQL to the onUpgrade() method in SQLiteOpenHelper class. Like:

<pre><code>@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 switch (oldVersion) {
 case 1:
 db.execSQL(SQL_MY_TABLE);

 case 2:
 db.execSQL("ALTER TABLE myTable ADD COLUMN myNewColumn TEXT");
 }
}
</code></pre>

blocks|key|503911|text|要向表中添加新列，需要使用ALTER。在android中，您可以在onUpgrade()中添加新列。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|503912|您可能想知道，onUpgrade()将如何添加新列？|503913|在实现SQLiteOpenHelper的子类时，需要在类构造函数中调用超类构造函数：super(context,+DB_NAME,+null,+1);。在那里，我已经传递了版本的1。|503914|当我将版本1更改为更高版本(2或更高版本)时，将调用onUpgrade()。并执行我想要做的SQL修改。我的类构造函数在更改版本后：|503915|public+DatabaseHelper(Context+context)+{
++++super(context,+DB_NAME,+null,+2);//version+changed+from+1+to+2
}|code-block|syntax|javascript|503916|超类构造函数将存储的SQLite数据库文件的版本与我传递给super()的版本进行比较。如果这些(以前的和现在的)版本号不同，就会调用onUpgrade()。|503917|代码应如下所示：|503918|@Override
public+void+onUpgrade(SQLiteDatabase+db,+int+oldVersion,+int+newVersion)+{
++++//+add+new+columns+to+migrate+to+version+2
++++if+(oldVersion+<+2)+{+
++++++++db.execSQL("ALTER+TABLE+"+%2B+TABLE_NAME+%2B+"ADD+COLUMN+school+VARCHAR(250)");
++++}
++++//+add+new+columns+to+migrate+to+version+3
++++if+(oldVersion+<+3)+{+
++++++++db.execSQL("ALTER+TABLE+"+%2B+TABLE_NAME+%2B+"ADD+COLUMN+age+INTEGER");
++++}
}|503919|entityMap^0|D|5|X|B|0|7|B|0|3|G|16|X|2H|1|0|5|1|E|1|Q|B|0|0|T|7|1V|B|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|16|8|@$9|17|A|18|B|C]|$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|1D|8|@$9|1E|A|1F|B|C]|$9|1G|A|1H|B|C]|$9|1I|A|1J|B|C]]|D|@]|E|$]]|$1|L|3|M|5|N|7|1K|8|@]|D|@]|E|$O|P]]|$1|Q|3|R|5|6|7|1L|8|@$9|1M|A|1N|B|C]|$9|1O|A|1P|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|U|3|V|5|N|7|1R|8|@]|D|@]|E|$O|P]]|$1|W|3|-4|5|6|7|1S|8|@]|D|@]|E|$]]]|X|$]]

To add a new column to the table you need to use <code>ALTER</code>. In android you can add the new column inside the <code>onUpgrade()</code>.

You may be wonder, how <code>onUpgrade()</code> will add the new column?

When you implementing a subclass of <code>SQLiteOpenHelper</code>, you need to call superclass constructor: <code>super(context, DB_NAME, null, 1);</code> in your class constructor. There I have passed <code>1</code> for version.

When I changed the version <code>1</code> to above(<code>2</code> or greater), <code>onUpgrade()</code> will invoked. And perform the SQL modifications which I intend to do.
My class constructor after changed the version:

<pre><code>public DatabaseHelper(Context context) {
 super(context, DB_NAME, null, 2);//version changed from 1 to 2
}
</code></pre>

SQL modifications checks like this, superclass constructor compares the version of the stored SQLite db file with the version that I passed to <code>super()</code>. If these(previous and now) version numbers are different <code>onUpgrade()</code> gets invoked.

Code should look like this:

<pre><code>@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 // add new columns to migrate to version 2
 if (oldVersion &lt; 2) { 
 db.execSQL("ALTER TABLE " + TABLE_NAME + "ADD COLUMN school VARCHAR(250)");
 }
 // add new columns to migrate to version 3
 if (oldVersion &lt; 3) { 
 db.execSQL("ALTER TABLE " + TABLE_NAME + "ADD COLUMN age INTEGER");
 }
}
</code></pre>

blocks|key|720033|text|首先，增加数据库版本号。然后在onUpgrade方法中，您可以检查列是否已经存在，如果不存在，则仅添加该列|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|720034|@Override
public+void+onUpgrade(SQLiteDatabase+db,+int+oldVersion,+int+newVersion)+{
+++if(!existsColumnInTable(db,+TABLE_NAME,+COLUMN_NAME)){
++++++db.execSQL("ALTER+TABLE+foo+ADD+COLUMN+COLUMN_NAME+INTEGER+DEFAULT+0");
+}+
+}

private+boolean+existsColumnInTable(SQLiteDatabase+inDatabase,+String+inTable,+String+columnToCheck)+{
++++Cursor+cursor+=+null;
++++try+{
++++++++//+Query+1+row
++++++++cursor+=+inDatabase.rawQuery("SELECT+*+FROM+"+%2B+inTable+%2B+"+LIMIT+0",+null);

++++++++//+getColumnIndex()+gives+us+the+index+(0+to+...)+of+the+column+-+otherwise+we+get+a+-1
++++++++if+(cursor.getColumnIndex(columnToCheck)+!=+-1)
++++++++++++return+true;
++++++++else
++++++++++++return+false;

++++}+catch+(Exception+Exp)+{
++++++++return+false;
++++}+finally+{
++++++++if+(cursor+!=+null)+cursor.close();
++++}
}|code-block|syntax|javascript|720035|这个方法是从这个链接Checking+if+a+column+exists+in+an+application+database+in+Android中提取出来的|720036|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/4719594/checking-if-a-column-exists-in-an-application-database-in-android^0|F|9|0|0|A|1T|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

first, increment the database version number. and then in <code>onUpgrade</code> method, you can check if the column exists already if not then only add the column
<pre><code>@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 if(!existsColumnInTable(db, TABLE_NAME, COLUMN_NAME)){
 db.execSQL(&quot;ALTER TABLE foo ADD COLUMN COLUMN_NAME INTEGER DEFAULT 0&quot;);
 } 
 }

private boolean existsColumnInTable(SQLiteDatabase inDatabase, String inTable, String columnToCheck) {
 Cursor cursor = null;
 try {
 // Query 1 row
 cursor = inDatabase.rawQuery(&quot;SELECT * FROM &quot; + inTable + &quot; LIMIT 0&quot;, null);

 // getColumnIndex() gives us the index (0 to ...) of the column - otherwise we get a -1
 if (cursor.getColumnIndex(columnToCheck) != -1)
 return true;
 else
 return false;

 } catch (Exception Exp) {
 return false;
 } finally {
 if (cursor != null) cursor.close();
 }
}
</code></pre>
this method is extracted from this link <a href="https://stackoverflow.com/questions/4719594/checking-if-a-column-exists-in-an-application-database-in-android">Checking if a column exists in an application database in Android</a>

blocks|key|503980|text|注意到没有答案查找列的存在：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|503981|Cursor+cursor+=+database.rawQuery("SELECT+*+FROM+"+%2B+MY_TABLE,+null);
int+columnIndex+=+cursor.getColumnIndex(MY_NEW_COLUMN);
if+(columnIndex+<+0)+{
+++database.execSQL("ALTER+TABLE+"+%2B+MY_TABLE+%2B+"+ADD+COLUMN+"+%2B+MY_NEW_COLUMN+%2B+"+TEXT");
}|code-block|syntax|javascript|503982|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Noticed no answers look for the existence of a column:
<pre><code>Cursor cursor = database.rawQuery(&quot;SELECT * FROM &quot; + MY_TABLE, null);
int columnIndex = cursor.getColumnIndex(MY_NEW_COLUMN);
if (columnIndex &lt; 0) {
 database.execSQL(&quot;ALTER TABLE &quot; + MY_TABLE + &quot; ADD COLUMN &quot; + MY_NEW_COLUMN + &quot; TEXT&quot;);
}
</code></pre>

I have one problem with Android <code>SQLite</code> database.

I have one table which contains one field.StudentFname
and that application is working fine with Android 2.3.1 and now if I add another field then my application is not working properly. 

Can anyone help me who knows database very well,

How to add new Column to Android SQLite Database?

数据库

Android

SQLite

我有一个关于Android SQLite数据库的问题。我有一个表，其中包含一个field.StudentFname，该应用程序在Android2.3.1上工作得很好，现在如果我添加另一个字段，那么我的应用程序就不能正常工作。谁能帮助我谁非常了解数据库，

问如何在安卓SQLite数据库中添加新列？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在安卓SQLite数据库中添加新列？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在安卓SQLite数据库中添加新列？
EN