Android SQLite异常语法错误（代码1）

Question

我正在使用SQLiteHelper创建一个数据库，当应用程序尝试运行时，我不断收到异常。

这是我收到的错误消息：引起原因：android.database.sqlite.SQLiteExcture：附近"Trip"：语法错误（代码1）：，而编译：创建表商务旅行支出（desc文本主键，餐整数不为空，饮料整数不为空，旅行整数不为空，住宿整数不为空，其他整数不为空，Receipt_Retained？Real NO NULL，Created_at文本NO NULL）；

js lang-js prettyprint-override">public class MySQLiteHelper extends SQLiteOpenHelper {

    public static final String TABLE_NAME = "Business Trip Expenditure";
    //Column Names
    public static final String COLUMN_NAME = "desc";
    public static final String MEAL_COST ="Meals";
    public static final String DRINK_COST = "Drinks";
    public static final String TRAVEL_COST = "Travel";
    public static final String ACCO_COST = "Accommodation";
    public static final String OTHER_COST = "Other";
    public static final String HAS_RECEIPT = "Receipt_Retained?";
    public static final String CREATED_AT = "Created_at";

    private static final String DATABASE_NAME = "task.db";
    private static final int DATABASE_VERSION = 1;

    // Database creation sql statement
    private static final String DATABASE_CREATE = "create table "
            + TABLE_NAME + "( " + COLUMN_NAME + " text primary key , " + MEAL_COST + " integer NOT NULL , " + DRINK_COST + " integer NOT NULL , " + TRAVEL_COST + " integer NOT NULL , " + ACCO_COST + " integer NOT NULL , " + OTHER_COST + " integer NOT NULL , " + HAS_RECEIPT + " real NOT NULL , " + CREATED_AT + " text NOT NULL );";

    public MySQLiteHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase database) {
        database.execSQL(DATABASE_CREATE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        Log.w(MySQLiteHelper.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);
    }
}

如果有人能帮助我创建表的语法，我将不胜感激，我知道这种形式的代码在语法方面很挑剔。

Answer 1

变化：

public static final String TABLE_NAME = "Business Trip Expenditure";

到

public static final String TABLE_NAME = "Business_Trip_Expenditure";