mysql - how to give number to occurrence in sql

Question

I want to give number to occurrence in sql result for example I have table like this:

ID| Name | Login Date
1 |John  | 12/1/2013
2 |John  | 15/1/2013
3 |Ben   | 12/2/2013

Now I want additional column to know what times they log in:

ID| Name | Visit times
1 |John  |1
2 |John  |2 
3 |Ben   |1 

Answer 1

SELECT  t1.ID
,       t1.Name
        (
        SELECT  COUNT(t2.ID)
        FROM    tablename AS t2
        WHERE   t1.Name = t2.Name
                and t2.ID <= t1.ID
        ) AS 'Visit times'
FROM    tablename AS t1;