mysql排序后加上序列

/**建表*/
CREATE TABLE ss(id INT(4),name VARCHAR(20));
/**插入测试数据*/
INSERT INTO ss VAlUES(1,'robin');
INSERT INTO ss VAlUES(2,'wentasy');
INSERT INTO ss VAlUES(3,'justdb');
INSERT INTO ss VAlUES(4,'wen');
INSERT INTO ss SELECT * FROM temp;
INSERT INTO ss SELECT * FROM temp;
INSERT INTO ss SELECT * FROM temp;
INSERT INTO ss SELECT * FROM temp;

/**查询序列*/
SELECT 
  @rownum := @rownum + 1 AS rownum,
  NAME 
FROM
  ss,(SELECT  @rownum := 0) temp