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.
Where I'm getting wrong?
Aucun commentaire:
Enregistrer un commentaire