Re: Adding row numbers to a select.

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/

Adding row numbers to a select.

Is there an easy way to add row numbers to the result of a select statement? -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want & give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For