SQLite 语法错误 - 逗号

Question

我正在尝试复制SQLite表中的一行，但是出现语法错误：

   android.database.sqlite.SQLiteException: near ",": syntax error (code 1): , while compiling: INSERT INTO tokens(colour, power, ts) SELECT (colour, power, ts) FROM tokens WHERE _id = 1

我的查询如下所示：

db.execSQL("INSERT INTO " + TABLE_TOKENS + "(" + COLUMN_COLOUR + ", " + COLUMN_POWER + ", " + COLUMN_TS + ")" +
            " SELECT (" + COLUMN_COLOUR + ", " + COLUMN_POWER + ", " + COLUMN_TS + ")" +
            " FROM " + TABLE_TOKENS +
            " WHERE _id = " + id);

对我来说，它看起来不错，我想没有逗号就行不通......

Answer 1

选择投影在语法上不正确。将SELECT (colour, power, ts)更改为SELECT colour, power, ts。