title: Android: saving data into SQLite database
body: <p>I am trying to save some data from editText to the SQLite database which is based on my Android device (and it should be based only on devices)...
  so I created <code>DatabaseHelper</code> class and I creating database there, here is code of this file:</p>
  
  <pre><code>package ru.vladimir.droid_spy;
  
  import android.content.Context;
  import android.database.sqlite.SQLiteDatabase;
  import android.database.sqlite.SQLiteDatabase.CursorFactory;
  import android.database.sqlite.SQLiteOpenHelper;
  import android.provider.BaseColumns;
  import android.util.Log;
  
  public class DatabaseHelper extends SQLiteOpenHelper 
  {
  
      public static final String TABLE_NAME = "phones";
      public static final String COLUMN_PHONES ="phone_number";
  
      private static final String DATABASE_NAME = "trusted_phone.db";
      private static final int DATABASE_VERSION = 1;
  
      //create database
      private static final String DATABASE_CREATE = "create table " + TABLE_NAME + " ( " + BaseColumns._ID + " integer primary key autoincrement, " + COLUMN_PHONES + " text not null);";
  
      public DatabaseHelper(Context context) 
      {
          super(context, DATABASE_NAME, null, DATABASE_VERSION);
          // TODO Auto-generated constructor stub
      }
  
      @Override
      public void onCreate(SQLiteDatabase db) 
      {
          // TODO Auto-generated method stub
  
          db.execSQL(DATABASE_CREATE);
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) 
      {
          // TODO Auto-generated method stub
          Log.w(DatabaseHelper.class.getName(),
                  "Upgrading database from version " + oldVersion + " to "
                      + newVersion + ", which will destroy all old data");
              db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
              onCreate(db);
      }
  
  }
  </code></pre>
  
  <p>and then I want to save some data from my Activity with this code:</p>
  
  <pre><code>try 
  {
      DatabaseHelper DBhelper = new DatabaseHelper(getBaseContext());
      //put DB in write mode
      SQLiteDatabase db = DBhelper.getWritableDatabase();
      //put variables
      ContentValues values = new ContentValues();
      //values.put(DatabaseHelper.COLUMN_ID, 1);
      values.put(DatabaseHelper.COLUMN_PHONES, txt_phone.getText().toString());
  
      //insert variables into DB
      long query = db.insert(DatabaseHelper.TABLE_NAME, null, values);
  
      //close DB
      db.close();
  } 
  catch(Exception e) 
  {
      System.out.println("Error: "+e.getLocalizedMessage());
  }
  </code></pre>
  
  <p>but when I saw LogCat logs, there was an error message:</p>
  
  <pre><code>07-27 00:04:50.463: E/SQLiteDatabase(15075): Error inserting phone_number=WEB
  07-27 00:04:50.463: E/SQLiteDatabase(15075): android.database.sqlite.SQLiteException: table phones has no column named phone_number: , while compiling: INSERT INTO phones(phone_number) VALUES (?)
  </code></pre>
  
  <p>I think that this error is telling about that I do not create a column in my database, but how I can't create it, if I create this column in <code>CREATE_DATABASE</code> variable?</p>