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