给mysql加上 rownum _转

转
http://home.21cto.com/forum_topic.php?forum_id=2&topic_id=22

给mysql 表加入rownum!!!

SELECT @rownum := @rownum +1 nowef,p.*
from emp p,
(select @rownum := 0) e
ORDER BY p.empno DESC;

+-------+-------+--------+-----------+------+------------+---------+---------+--------+
| nowef | EMPNO | ENAME  | JOB       | MGR  | HIREDATE   | SAL     | COMM    | deptno |
+-------+-------+--------+-----------+------+------------+---------+---------+--------+
|     1 |  7369 | SMITH  | CLERK     | 7902 | 1980-10-10 |  800.00 |    NULL |     20 |
|     2 |  7499 | ALLEN  | SALESMAN  | 7698 | 1981-10-10 | 1600.00 |  300.00 |     30 |
|     3 |  7521 | WARD   | SALESMAN  | 7698 | 1981-10-10 | 1250.00 |  500.00 |     30 |
|     4 |  7566 | JONES  | MANAGER   | 7839 | 1981-10-10 | 2975.00 |    NULL |     20 |
|     5 |  7654 | MARTIN | SALESMAN  | 7698 | 1981-10-10 | 1250.00 | 1400.00 |     30 |
|     6 |  7698 | BLAKE  | MANAGER   | 7839 | 1981-10-10 | 2850.00 |    NULL |     30 |
|     7 |  7782 | CLARK  | MANAGER   | 7839 | 1981-10-10 | 2450.00 |    NULL |     10 |
|     8 |  7788 | SCOTT  | ANALYST   | 7566 | 1987-10-10 | 3000.00 |    NULL |     20 |
|     9 |  7839 | KING   | PRESIDENT | NULL | 1981-10-10 | 5000.00 |    NULL |     10 |
|    10 |  7844 | TURNER | SALESMAN  | 7698 | 1981-10-10 | 1500.00 |    0.00 |     30 |
|    11 |  7876 | ADAMS  | CLERK     | 7788 | 1987-10-10 | 1100.00 |    NULL |     20 |
|    12 |  7900 | JAMES  | CLERK     | 7698 | 1981-10-10 |  950.00 |    NULL |     30 |
|    13 |  7902 | FORD   | ANALYST   | 7566 | 1981-10-10 | 3000.00 |    NULL |     20 |
|    14 |  7934 | MILLER | CLERK     | 7782 | 1982-10-10 | 1300.00 |    NULL |     10 |
+-------+-------+--------+-----------+------+------------+---------+---------+--------+
14 rows in set (0.00 sec)