From: Victor Sudakov
Date: March 16 1999 9:22am
Subject: current row number
List-Archive: http://lists.mysql.com/mysql/309
Message-Id: <199903160922.QAA17911@gateway.dtu.tsu.ru>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit


Colleagues.

Is there a function in mySQL to return the current row number in a query
(not any unique record id, just a sequential number)? I did not find that in
the documentation among the functions. It is useful for some reports.

Thanks for any input.

-- 
Victor Sudakov
VAS4-RIPE, http://www.dtu.tsu.ru/~vas
PGP Public Key: finger vas@stripped