status is basically used for display Always new row is added with status 0 Once its been displayed the status has to be changed to 1. Its just to track of rows displayed and new added rows. On Sun, Apr 19, 2009 at 12:51 PM, John Machin <sjmac...@lexicon.net> wrote:
> On 19/04/2009 5:06 PM, thirunavukarasu selvam wrote: > > I tried the following query > > update table-name SET status='1' where status='0' limit 2 > > status - column name. > > What is "status - column name" meant to do? > > > I am using sqlite-amalgamation-3.6.13.tar.gz source from sqlite.org. > > > > I configured it with the following command. > > > > CFLAGS="-0s -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT" ./configure > > > > Then did a "make". > > > > With newly compiled one, when i try the above said query it gives the > > following error. > > > > SQL error: near "limit": syntax error > > http://www.sqlite.org/compile.html#enable_update_delete_limit > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users