MySQL的查询编号
查询编号:
SELECT @row := @row +1 AS row
t.* from table t ,(SELECT @row :=0)r
说明:
@row := @row +1 AS row
查询标号并把标号命名为row
t.*
t表别名,t.*表全部数据
from table t
数据来自table表 t 等于把table表命名为t,
(select @row := 0 )
r 表的标号从0开始