æ¤ç»æå·²éªè¯ã SELECT (SELECT COUNT(id) FROM æ¥è¯¢è¡¨ AS tbl1 WHERE tbl1.id<=tbl2.id) as seq, * FROM æ¥è¯¢è¡¨ AS tbl2 ORDER BY 1 ; å ¶ä¸ id ä¸ºä¸»é® åã æ¥è¯¢åºæ¥ç ç»ææ¯0ï¼1ï¼2ï¼3ï¼.....ã
å¦æè¦ä»¥1ï¼2ï¼3ï¼4ï¼5ï¼6ï¼7ï¼....... å¼å§çååæï¼ SELECT (SELECT COUNT(id) FROM æ¥è¯¢è¡¨ AS tbl1 WHERE tbl1.id<=tbl2.id)+1 as seq, * FROM æ¥è¯¢è¡¨ AS tbl2 ORDER BY 1 ;