Is they a way to count the number of records in a table using a select?
I recall in my earlier Sybase days the select clause supported
a 'COUNT' keyword. How can I do this in msql?
Second question: Are the _rowid's in sequential order without any gaps?
Let's say there are 100 records in table foo, could I select 10 records
at a time using
$x = $y = 0;
while($x < 100)
{
$y = $x + 10;
SELECT * FROM foo WHERE _rowid >= $x AND _rowid < $y'
do some stuff
$y = $y + 10;
}
Thank you.
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:52 EST