.SQLiteException：near“，”：语法错误（代码1）：，编译时：

Question

我不知道为什么我得到这个错误。

@Override 
public void onCreate(SQLiteDatabase db){ 

    String SQL_CREATE_GOAL_TABLE = "CREATE TABLE"+ GoalContract.GoalEntry.TABLE_NAME + " (" 
      + GoalContract.GoalEntry._ID + "INTEGER PRIMARY KEY," 
      + GoalContract.GoalEntry.COLUMN_GOAL_NAME + "TEXT);"; 
    db.execSQL(SQL_CREATE_GOAL_TABLE); 

} 

Answer 1

你错过许多空间：

String SQL_CREATE_GOAL_TABLE = "CREATE TABLE "+ GoalContract.GoalEntry.TABLE_NAME + " (" 
      + GoalContract.GoalEntry._ID + " INTEGER PRIMARY KEY," 
      + GoalContract.GoalEntry.COLUMN_GOAL_NAME + " TEXT);"; 

注意额外的空间'table '后，' Integer'和' TEXT'之前。

如果在生成的SQL中有语法错误，调试和查看生成的String会很有用。