vendredi 26 février 2016

Update first n records in SQLite

I want to update first n records in my SQLite DB from android app. Following are the queries that I've tried so far. I'm getting syntax error near order.

update label set label_is_used = 1 where label_name !='temp' and label_cnt != 0 order by label_cnt desc limit 3
------------------------------------
update label set label_is_used = 1 where label_name !='temp' and label_cnt != 0 order by label_cnt limit 3

From the docs, this should work as it fits in the syntax. syntax

Where I'm getting wrong?

Aucun commentaire:

Enregistrer un commentaire