From: Michael Widenius Date: March 16 1999 2:23pm Subject: current row number List-Archive: http://lists.mysql.com/mysql/337 Message-Id: <14062.26845.295626.297774@monty.pp.sci.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "Victor" == Victor Sudakov writes: Victor> Colleagues. Victor> Is there a function in mySQL to return the current row number in a query Victor> (not any unique record id, just a sequential number)? I did not find that in Victor> the documentation among the functions. It is useful for some reports. Victor> Thanks for any input. Hi! Sorry, not yet; I will look at adding this to MySQL 3.23 Regards, Monty