mardi 19 mai 2015

SQLite DataBase query with where

I am new to mobile application design , I am trying to design an android , I use a database sqlite , my only problem is the query I have a table and I want to select all the names in this table whose id is 1

I'm tried this, but I know it's totaly false!

String selectQuery = "SELECT" +KEY_ARRET +" FROM " + TABLE_NAME + "where _idligne "  = ' " +1+ '";

   SQLiteDatabase db = this.getReadableDatabase();
   Cursor cursor = db.rawQuery(selectQuery, null);

Thank you for your help ! :)

Aucun commentaire:

Enregistrer un commentaire