SELECT (@rownum /*'*/:=/*'*/@rownum+1) as rownum, a.* FROM tablename a, (select @rownum /*'*/:=/*'*/0) as init 复制代码
本文共 167 字，大约阅读时间需要 1 分钟。
SELECT (@rownum /*'*/:=/*'*/@rownum+1) as rownum, a.* FROM tablename a, (select @rownum /*'*/:=/*'*/0) as init 复制代码
转载于:https://juejin.im/post/5c2d61d2f265da613a542324