[MYSQL]ROWNUM

SELECT @RNUM := @RNUM + 1 AS ROWNUM,
       EVENT_SCHEMA,
       EVENT_NAME,
       INTERVAL_FIELD,
       EVENT_DEFINITION,
       LAST_EXECUTED
FROM information_schema.EVENTS, (SELECT @RNUM := 0) R
ORDER BY LAST_EXECUTED DESC