MySql - Selecting Total Results Returned In Each Row
===

I'm trying to count total number of results on each row of my `SELECT` query. Something like:

    SELECT id, COUNT(*) FROM mytable;

But this returns just a single row with the count. How do I get the total number of returned rows on every row?

I've tried achieve this using: SELECT @i=@i+1 (in a sub query) but it doesn't work. Also, tried grouping by id but that doesn't help either.

Is there some MySql function that returns total number of rows returned so that it could be added into each row of the result (for calculations)?