MySQL 下面没有RowNum,就是从0开始累加. 排序后序号却无法得到
SELECT @rownum:=@rownum+1 rownum, ACCOUNT_NO From (SELECT @rownum:=0,a_account.* FROM a_account WHERE ACCOUNT_NO!='' ORDER BY ACCOUNT_NO limit 10) a
MySQL 下面没有RowNum,就是从0开始累加. 排序后序号却无法得到
SELECT @rownum:=@rownum+1 rownum, ACCOUNT_NO From (SELECT @rownum:=0,a_account.* FROM a_account WHERE ACCOUNT_NO!='' ORDER BY ACCOUNT_NO limit 10) a