samedi 3 octobre 2015

How to get/delete multiple rows in SQLITE table in iOS?

My table in SQLITE is in the following format.

id   name      date      height
 1    tt     12-2-15       120
 2    ss     15-3-15       110
 3    tt     14-5-15       120
 ....
 10   tt     19-6-15       130

(1)I like to get all rows under name tt in one instruction, then put into two dimensional array. How can i implement it?

(2)How to delete all rows under name tt in one instruction?

My code is in iOS. I couldn't find solution easily. Thanks

Aucun commentaire:

Enregistrer un commentaire