What language are you writing in? Why do you need to know the # of rows? What are you doing with that information? The select itself does stop (obviously). >From a Windows command prompt you can just do this echo SELECT * FROM myTable WHERE _rowid_ >= 100 AND _rowid_ <= 102 | sqlite3 mytable.db
And then you can redirect the output wherever hyou want. Just add quotes around the select statement for Unix. Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems ________________________________ From: sqlite-users-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 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: [sqlite] SQL script help. Or you can do: SELECT * FROM myTable WHERE _rowid_ IN (100, 101, 102) depending what you want ----- "Simon Slavin" <slav...@bigfraud.org> 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 myTable WHERE _rowid_ = 102; > > SELECT * FROM myTable WHERE _rowid_ BETWEEN 100 AND 102 > > or > > SELECT * FROM myTable WHERE _rowid_ >= 100 AND _rowid_ <= 102 > > will give identical results. Technically speaking you might want to add > 'ORDER BY _rowid_' to the end of those if the order matters. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
