"thirunavukarasu selvam" <gs.th...@gmail.com> wrote in message news:5b5250670904190006h7faba51ejbd9c392c0584c...@mail.gmail.com > I need a help in using update query along with limit option. > I tried the following query > update table-name SET status='1' where status='0' limit 2 > status - column name.
You could use this equivalent query with "standard" SQLite build: update tableName set status = '1' where rowid in (select rowid from tableName where status='0' limit 2); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
