mysql 排序后， 如何加上序列号？

mysql>

select

*

from

a

+-----+

|

col

|

+-----+

|

0

|

|

1

|

|

2

|

|

3

|

|

4

|

|

5

|

|

6

|

|

7

|

+-----+

8

rows

in

set

(0.00

sec)

mysql>

set

@i

:=

0

select

@i

:=

@i

+

1

as

`order`,

a.*

from

a

order

by

col

desc

+-------+-----+

|

order

|

col

|

+-------+-----+

|

1

|

7

|

|

2

|

6

|

|

3

|

5

|

|

4

|

4

|

|

5

|

3

|

|

6

|

2

|

|

7

|

1

|

|

8

|

0

|

+-------+-----+

8

rows

in

set

(0.00

sec)

mysql>

alter table abc add num int unsigned auto_increment

如果同时为主键的话,可以这样写

alter table abc add num int unsigned primary key auto_increment

__________________________________________

to:数据库强者 不ok

0 这是个老话题了

set @rownum=0

select a.*, b.*, @rownum := @rownum +1 as rownum from a, b

1 缺点：每次调用前需设置 set @rownum=0否则在请求的同一次会话中，这个值会累加。

---