sqlite exception error SELECT command

Question

Caused by: android.database.sqlite.SQLiteException: near "FROM": syntax error (code 1): , while compiling: SELECT _id, FROM TRACKS WERE _id=9

 String test = "SELECT _id, FROM TRACKS WERE _id="+"9";

    Cursor cursor = database.rawQuery(test, null);

Did not see the Point :( any help

Maybe there is a error in my Statement but it didn't work

That comma looks out of place _id,

David Medenjak
– David Medenjak

2016-03-30 20:20:52 +00:00
Commented Mar 30, 2016 at 20:20 — David Medenjak
– David Medenjak, Commented Mar 30, 2016 at 20:20

Diego Torres Milano · Accepted Answer · 2016-03-30 20:35:39Z

2

No comma after id and WERE should be WHERE. Also consider using [rawQuery()](http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#rawQuery(java.lang.String, java.lang.String[], android.os.CancellationSignal)] with selectionArgs to avoid having to concatenate query and values as you did in +id=+9.

answered Mar 30, 2016 at 20:35

Diego Torres Milano

69.9k9 gold badges116 silver badges145 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chad White Over a year ago

Ok, now I have all done - and the command seems to work - seems error is in another line :( thank you anyway to all three

0x5050 · Accepted Answer · 2016-03-30 20:33:34Z

2

SELECT _id, FROM TRACKS WERE _id="+"9"

'WERE' should be WHERE

answered Mar 30, 2016 at 20:33

0x5050

1,2182 gold badges17 silver badges34 bronze badges

1 Comment

Chad White Over a year ago

So sad - i would like to program and I'm blind :)) thank you but it didn't Change anything - same error

Collectives™ on Stack Overflow

sqlite exception error SELECT command

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related