Thanks for ur equivalent query.
Its working as expected
using rowid will not be prob rightAs long as its value is unique.
Regards,
Thiru.
On Sun, Apr 19, 2009 at 8:33 PM, Igor Tandetnik wrote:
> "thirunavukarasu selvam"
> wrote in message
> news:5b5250670904190006h7faba51ejbd9c392c0584c
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 wrote:
> On 19/04/2009 5:06 PM, thirunavukarasu selvam wrote:
"thirunavukarasu selvam"
wrote in message
news:5b5250670904190006h7faba51ejbd9c392c0584c...@mail.gmail.com
> 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
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 configur
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/
5 matches
Mail list logo
