SQL Column Numbering - MySQL

Question

This is a newbie question in sql.

Basically, I want an extra column to be returned with my select statement for the row number. I am using mysql.

For example:

select * from friends

David
Steve
Joe

What is the syntax:

1  David
2  Steve
3  Joe

Answer 1

From: http://markmal.blogspot.com/2006/04/oracle-like-rownum-in-mysql.html

SELECT @rownum:=@rownum+1 rownum, t.*FROM (SELECT @rownum:=0) r, mytable t;

Answer 2

In SQL Server 2005 and above, you can use the Row_Number function .

Answer 3

- , , . - . Paul .

MySql ROWNUM, Oracle, Row_Number(), MS SQL Server, .

Edit:

, SQL, .

Answer 4

proc

CREATE TABLE #Foo (
        [FooId] [int] IDENTITY(1,1) NOT NULL,
        [Name] varchar(255)
)

SELECT *
FROM Friends
INTO #Foo

SELECT *
FROM #Foo

Answer 5

, , . , ROWNUM .

SQL, , ROW_NUMBER() - @YonahW; .