SQLite syntax error - a comma

Question

I'm trying to copy a row in a SQLite table, but I get a syntax error:

   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

My query looks like this:

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);

For me it looks fine and I guess it wouldn't work without commas...

http://stackoverflow.com/q/16838896/438992 – Dave Newton May 10 '17 at 20:05 — Dave Newton, May 10 '17 at 20:05
Plus you should definitely Google "SQL injection" – Marged May 10 '17 at 20:34 — Marged, May 10 '17 at 20:34

score 1 · Accepted Answer · answered May 10 '17 at 20:06

1

The select projection is syntactically not correct. Change SELECT (colour, power, ts) to SELECT colour, power, ts.

answered May 10 '17 at 20:06

laalto

150,114
66
286
303

I went through many threads regarding copying a row and in every one of them there were these brackets. Can't believe no one pointed that out. It works now, thanks! – Rafał Mądry May 10 '17 at 20:47

SQLite syntax error - a comma

1 Answers1