mysql模拟rownum的一个方法
时间：2021-07-01 10:21:17
帮助过：2人阅读
select * from t2;
+----+---------------------+
| id
| d
|
+----+---------------------+
| 1 | 2015-08-02 15:
13:
59 |
| 3 | 2015-08-05 16:
56:
23 |
| 4 | 2015-08-05 16:
56:
24 |
| 6 | 2015-08-05 16:
56:
26 |
| 7 | 2015-08-05 16:
56:
28 |
| 8 | 2015-08-05 16:
56:
29 |
+----+---------------------+
6 rows
in set (
0.00 sec)
mysql> set @x=0;
Query OK, 0 rows affected (
0.00 sec)
mysql> select @x:
=ifnull(
@x,
0)
+1 as rownum,d
as time
from t2;
+--------+---------------------+
| rownum
| time
|
+--------+---------------------+
| 1 | 2015-08-02 15:
13:
59 |
| 2 | 2015-08-05 16:
56:
23 |
| 3 | 2015-08-05 16:
56:
24 |
| 4 | 2015-08-05 16:
56:
26 |
| 5 | 2015-08-05 16:
56:
28 |
| 6 | 2015-08-05 16:
56:
29 |
+--------+---------------------+
6 rows
in set (
0.00 sec)
mysql模拟rownum的一个方法
标签：
