MySQL 下面沒有RowNum、Rowid,排序后序號卻無法得到,比較麻煩!SELECT @rownum:=@rownum+1 rownum, ids,t.* From(SELECT @rownum:=0,s.* FROM information s WHERE ids!='' ORDER BY ids limit 10) tSELECT @rownum:=@rownum+1 rownum, ids,t.* From(SELECT @rownum:=0,s.* FROM information s WHERE ids!='' ORDER BY ids limit 10) t
新聞熱點
疑難解答