title: Creating table in SQLite issue
body: <p>I have written a code that get information from json file related to specific YouTube video and then stores the information I need in my database.</p>
  
  <p>The parsing from json file has no problem. Only problem I've got is the creation of table in my data base. I am confused because I don't  know what is the problem.</p>
  
  <p>Here is the full stack-trace:</p>
  
  <p>07-30 12:50:31.933: E/Database(539): Failure 1 (near "tableYOUTUBE_database": syntax error) on 0x135ad8 when preparing 'create tableYOUTUBE_database(video_Name text not null , video_Descrption text not null , video_Img text not null , video_Url text not null , video_CountView integer , video_LIKES integer , video_CommentCount integer ) '.</p>
  
  <p>And here is my database code:</p>
  
  <pre><code>package com.example.tstnetconnwithjson.db;
  
  import android.content.Context;
  import android.database.sqlite.SQLiteDatabase;
  import android.database.sqlite.SQLiteDatabase.CursorFactory;
  import android.database.sqlite.SQLiteOpenHelper;
  import android.util.Log;
  
  public class youtube_db extends SQLiteOpenHelper {
  
  
      public static final String dataBase_NAME="YOUTUBE_database";
      private static final  int dataBase_VERSION=1;
      private static final  String dataBase_TABLE="youtube_VIDEOS";
      public static final String[] COLS_List={"video_Name","video_Descrption","video_Img","video_Url","video_CountView","video_LIKES","video_CommentCount"};
  
      ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
      //end of declaring attributes and tables conents
      public youtube_db(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(
              "create table" + dataBase_NAME + "(" + COLS_List[0] +" text not null , "+ COLS_List[1]
                  +" text not null , "+ COLS_List[2]+" text not null , "+COLS_List[3]+" text not null , "+COLS_List[4]+" integer , "+COLS_List[5]
                  +" integer , "+COLS_List[6]+" integer ) ");             
  
  
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
          // TODO Auto-generated method stub
          Log.i("in the upgrade", "ok");
  
      }
  
  }
  </code></pre>
  
  <p>And here is the function that would insert the information in my database:</p>
  
  <pre><code>package com.example.tstnetconnwithjson.db;
  
  import com.example.tstnetconnwithjson.tables.videos;
  
  import android.content.ContentValues;
  import android.content.Context;
  import android.database.sqlite.SQLiteDatabase;
  import android.util.Log;
  
  public class youtubeDataBaseManager {
  
      SQLiteDatabase SQL_db;
      youtube_db my_Database;
  
  
      public youtubeDataBaseManager(Context c){
  
          my_Database=new youtube_db(c);
          SQL_db= my_Database.getWritableDatabase();
  
      }//end of costructor
  
      public long insert_Youtube_Info( videos video){
          ContentValues contentValues = new ContentValues(); 
  
          contentValues.put(youtube_db.COLS_List[0], video.getVideoname());
          contentValues.put(youtube_db.COLS_List[1], video.getDecscrption());
          contentValues.put(youtube_db.COLS_List[2], video.getImageurl());
          contentValues.put(youtube_db.COLS_List[3], video.getVediourl());
          contentValues.put(youtube_db.COLS_List[4], "not set yet");
          contentValues.put(youtube_db.COLS_List[5], "not set yet");
          contentValues.put(youtube_db.COLS_List[6], "not set yet");
  
          long addResult ;
          addResult= SQL_db.insert(youtube_db.dataBase_TABLE, null, contentValues); 
  
  
          if(addResult==-1)
          {
              Log.i("add video", "add error....  ");
  
          }
          else
          {
              Log.i("add video", "add:ok....  ");
          }
          return  addResult;
  
  
  
      }
  </code></pre>
  
  <p>Can anyone tell me what is the problem?</p>