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


/**建表*/
CREATE TABLE ss(id INT(4),name VARCHAR(20