MySQL | 为查询结果增加一个自增列

SET @rownum=0;
SELECT (@rownum :=@rownum+1),colname FROM `tablename`;

SELECT @rownum :=@rownum+1,colnum FROM (SELECT @rownum :=0) a,`tablename`;

SELECT @rownum :=@rownum+1,colnum 
FROM (SELECT @rownum :=(SELECT MAX(colnum) FROM `tablename`)) a,`tablename`;

如果觉得我的文章对你有用，请随意赞赏

此处评论已关闭