Re: Adding row numbers to a select.

[Michael Stassen]

Chris W wrote:

Is there an easy way to add row numbers to the result of a select statement?

With a user variable:

  SET @i = 0;

  SELECT @i:= @i + 1 AS 'Row', ...

Michael

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