/**建表*/
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
mysql排序后加上序列
最新推荐文章于 2021-08-17 00:13:43 发布