title: How to add two new Column to Android SQLite Database?
body: <p>I have one application on android market , now i want to change the database filed . I want to add two new field to particular table.Can you help me how to add two new columns to table ?</p>
  
  <p>Here is my code.</p>
  
  <pre><code> private static final String ALTER_USER_TABLE = "ALTER TABLE user_table ADD user_society text,user_street1 text;"; 
  
   @Override
   public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) 
   {
      db.execSQL(ALTER_USER_TABLE);
   }
  </code></pre>
  
  <p>I got the following error after executing .</p>
  
  <pre><code>W/System.err(  717): android.database.sqlite.SQLiteException: near ",": syntax error: ALTER TABLE user_table ADD user_society text,user_street1 text;
  W/System.err(  717):    at android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
  W/System.err(  717):    at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1727)
  W/System.err(  717):    at com.kbobs.org.database.Database$DatabaseHelper.onUpgrade(Database.java:48)
  W/System.err(  717):    at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:108)
  W/System.err(  717):    at com.kbobs.org.database.Database.OpenDatabase(Database.java:54)
  W/System.err(  717):    at com.kbobs.org.ui.Login$2.handleMessage(Login.java:222)
  W/System.err(  717):    at android.os.Handler.dispatchMessage(Handler.java:99)
  W/System.err(  717):    at android.os.Looper.loop(Looper.java:123)
  W/System.err(  717):    at android.app.ActivityThread.main(ActivityThread.java:4627)
  W/System.err(  717):    at java.lang.reflect.Method.invokeNative(Native Method)
  W/System.err(  717):    at java.lang.reflect.Method.invoke(Method.java:521)
  W/System.err(  717):    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
  W/System.err(  717):    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
  </code></pre>