Hello all,

Still a newbie with MySQL, I am running version 4.01 and a Linux box. We are writing information
into the tables at a regular rate approx 20 time per hour. with 22 rows of information.


What I am trying to work out is how to read the last 22 rows of information that has been written to
the Database.


Select (count(*)-22) from Database

will return me the record number 22 numbers from the very last record. This is great but
when I try and incoperate the (count(*)-22) into a query I get responce about grouping.


Just wondering if any one else has had a need to return the last few rows in a table that might be able to shed some light on the subject !

regards Matthew Richardson


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to