Re: [sqlite] SQL script help.

sers-boun...@sqlite.org on behalf of Kirk Clemons Sent: Thu 8/26/2010 1:01 PM To: 'General Discussion of SQLite Database' Subject: EXTERNAL:Re: [sqlite] SQL script help. 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

Re: [sqlite] SQL script help.

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

Re: [sqlite] SQL script help.

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

Re: [sqlite] SQL script help.

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" <slav...

Re: [sqlite] SQL script help.

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

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: > > On 26 Aug 2010, at 3:39pm, Kirk Clemons wrote: > > > SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE > > _rowid_

Re: [sqlite] SQL script help.

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

[sqlite] SQL script help.

I have heard about SQL scripts that can automate some processes. Is it possible to write a script that performs the following on an entire database? SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE _rowid_ = 101; SELECT * FROM myTable WHERE _rowid_ = 102; Regards, Kirk