/*
* 把查询到的数据加上一个自动编号字段
*/
SELECT
@rownum := @rownum + 1 AS rownum,
one.name
FROM
(SELECT @rownum := 0) r,
test.user one
/*
* 把查询到的数据加上一个自动编号字段
*/
SELECT
@rownum := @rownum + 1 AS rownum,
one.name
FROM
(SELECT @rownum := 0) r,
test.user one