SqliteException：靠近“between”：语法错误（代码1）

Question

私有静态final int DATABASE_VERSION=1；私有静态最终字符串DATABASE_NAME=“unitconversion.db”；

private static final String SQL_CREATE_ENTRIES =
        "CREATE TABLE " + DatabaseContract.FeedEntry.TABLE_NAME + " (" +
                DatabaseContract.FeedEntry._ID + " INTEGER PRIMARY KEY," +
                DatabaseContract.FeedEntry.COLUMN_NAME_UNIT_FROM + " TEXT," +
                DatabaseContract.FeedEntry.COLUMN_NAME_UNIT_CONVERTING_TO + " TEXT," +
                DatabaseContract.FeedEntry.COLUMN_NAME_Ratio + " TEXT)";

android.database.sqlite.SQLiteException: near "between": syntax error (code 1): , while compiling: CREATE TABLE Conversions between units (_id INTEGER PRIMARY KEY,Converting from unit TEXT,Converting to unit TEXT,Ratio TEXT)

Answer 1

您的表名有空格单元之间的转换（或者您应该更新databaseContract.feedentry.table_name)。

您可能希望将其命名为conversions_between_units，但如果表名中确实有空格，则应该在单引号或双引号之间：

"CREATE TABLE \"" + DatabaseContract.FeedEntry.TABLE_NAME + "\" ("

尽管SQLite支持单引号，但便携的方法是使用双引号。

对于也包含空格的COLUMN_NAME_UNIT_FROM和COLUMN_NAME_UNIT_CONVERTING_TO也是如此。