title: E/SQLiteLog﹕ (1) near "TABLEaccount": syntax error
body: <p>I am getting this error in my app when I try to write to database
  <code>E/SQLiteLog﹕ (1) near "TABLEaccount": syntax error</code></p>
  
  <p>I cant figure it out why? Here is my code for SQLite databse. I am attaching the complete code for database class here</p>
  
  <p>package com.astrolabe.tcpremote1;</p>
  
  <pre><code>import android.content.ContentValues;
  import android.content.Context;
  import android.database.sqlite.SQLiteDatabase;
  import android.database.sqlite.SQLiteOpenHelper;
  
  import java.sql.SQLDataException;
  import java.sql.SQLException;
  
  public class accountsDB {
  
      //private variables
      public static final String KEY_ROWID = "_id";
      public static final String KEY_CTYPE = "c_type";
      public static final String KEY_SNAME = "s_name";
      public static final String KEY_SNUMB = "s_numb";
      public static final String KEY_USRN = "user_name";
      public static final String KEY_PASS = "password";
      public static final String KEY_EMPTY = "empty";
  
      private static final String DATABASE_NAME ="account.db";
      private static final String DATABASE_TABLE ="accounts";
      private static final int DATABASE_VERSION =1;
  
      private DbHelper  ourHelper;
      private final Context  ourContext;
      private SQLiteDatabase  ourDatabase;
  
      public long createEntry(String ctype, String siteName, String siteNum, String username, String pass) {
  
          ContentValues cv= new ContentValues();
          cv.put(KEY_CTYPE,ctype);
          cv.put(KEY_SNAME,siteName);
          cv.put(KEY_SNUMB,siteNum);
          cv.put(KEY_USRN,username);
          cv.put(KEY_PASS,pass);
          //cv.put(KEY_EMPTY,0);
          return ourDatabase.insert(DATABASE_TABLE,null,cv);
      }
  
      private static class DbHelper extends SQLiteOpenHelper {
           public DbHelper(Context context){
               super(context,DATABASE_NAME,null,DATABASE_VERSION);
  
           }
  
           @Override
           public void onCreate(SQLiteDatabase db) {
               db.execSQL("CREATE TABLE"+ DATABASE_NAME + "(" +
                  KEY_ROWID + "INTEGER PRIMARY KEY AUTOINCREMENT"
                       + KEY_CTYPE + "TEXT NOT NULL,"
                       +  KEY_SNAME + "TEXT NOT NULL,"
                       +  KEY_SNUMB + "TEXT NOT NULL,"
                       +  KEY_USRN + "TEXT NOT NULL,"
                       +  KEY_PASS + "TEXT NOT NULL,"
                       +  KEY_EMPTY + "INTEGER);"
                  );
  
           }
  
           @Override
           public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
               db.execSQL("DROP TABLE IF EXISTS" +DATABASE_TABLE);
               onCreate(db);
  
           }
       }
  
      public accountsDB (Context c)
      {
          ourContext= c;
      }
      public accountsDB open() throws SQLException
      {
          ourHelper = new DbHelper(ourContext);
          ourDatabase = ourHelper.getWritableDatabase();
          return  this;
      }
      public  void close()
      {
          ourHelper.close();
      }
  
    }
  </code></pre>