s there is a way to tell sqlite to
stop at the end?
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Israel Lins Albuquerque
Sent: Thursday, August 26, 2010 10:58 AM
To: General Discussion of SQLite Database
Subject: Re: [sqli
Kirk,
You can use the aggregate function count. So if you have a table
called foo, do this,
SELECT COUNT(*) FROM foo;
That'll give you the number of rows in the table.
Denis
On Fri, Aug 27, 2010 at 6:30 AM, Paul Corke wrote:
> On 26 August 2010 19:02, Kirk Clemons wrote:
>
> > I would
On 26 August 2010 19:02, Kirk Clemons wrote:
> I would like to be able to create an output log of each row. But I
> need to know how many rows there are in the database unless there is
> a way to tell sqlite to stop at the end?
Do you just want:
SELECT * FROM myTable
which will return every r
Of Israel Lins Albuquerque
Sent: Thursday, August 26, 2010 10:58 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQL script help.
Or you can do:
SELECT * FROM myTable WHERE _rowid_ IN (100, 101, 102)
depending what you want
- "Simon Slavin" escreveu:
>
Thank you,
So how do I get the total count of rows?
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Simon Slavin
Sent: Thursday, August 26, 2010 8:59 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQL
Or you can do:
SELECT * FROM myTable WHERE _rowid_ IN (100, 101, 102)
depending what you want
- "Simon Slavin" escreveu:
>
> On 26 Aug 2010, at 3:39pm, Kirk Clemons wrote:
>
> > SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE
> > _rowid_ = 101; SELECT * FROM m
On 26 Aug 2010, at 3:39pm, Kirk Clemons wrote:
> SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE
> _rowid_ = 101; SELECT * FROM myTable WHERE _rowid_ = 102;
SELECT * FROM myTable WHERE _rowid_ BETWEEN 100 AND 102
or
SELECT * FROM myTable WHERE _rowid_ >= 100 AND _rowid_
7 matches
Mail list logo
