android - SQLite 异常查询错误

Question

谁能告诉我这是否正确？

public static final String DATABASE_CREATE = ("CREATE TABLE" + TABLE_NAME + "(" +
                                            COLUMN_ID + "INTEGER PRIMARY KEY AUTOINCREMENT,"+ 
                                            COLUMN_TITLE + "text not null," + 
                                            COLUMN_CATEGORY + "text not null," + 
                                            COLUMN_IMAGE + "text not null);");

错误是SQLiteException

Answer 1

列和表名之间缺少空格。这是更正后的查询:

"CREATE TABLE " + TABLE_NAME + "(" +
 COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"+ 
 COLUMN_TITLE + " text not null," + 
 COLUMN_CATEGORY + " text not null," + 
 COLUMN_IMAGE + " text not null);");

此外，请注意查询末尾的分号。这是非常有问题的 - 我的意思是在某些设备上这个符号可能会导致错误(更安全的是不要使用它)。

希望我能帮助您解决问题。