Hello all, Am new to sqlite. 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.
I need to update the value of status columns having value 0 to value 1. That too for only 2 records/rows. 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 Is there anything else i need to modify in the code? Can anyone guide me in using the query. Any other alternate query which will do the same purpose which am looking is also welcome.. Thanks in advance for ur help. Regards, Thiru. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
