"thirunavukarasu selvam" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
