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
