MYSQL查询增加自增长序号

SELECT @ROWNUM := @ROWNUM + 1 IDCODE, @ROWNUM, ID, NAME FROM SYS_AREA, (SELECT @ROWNUM := 0) NUM