Thanks for ur equivalent query. Its working as expected.... using rowid will not be prob right....As long as its value is unique. Regards, Thiru.
On Sun, Apr 19, 2009 at 8:33 PM, Igor Tandetnik <[email protected]> wrote: > "thirunavukarasu selvam" > <[email protected]> wrote in message > news:[email protected]<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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
