sql_mode=ORACLE: ROWNUM

select rownum, table_schema, table_name from information_schema.tables;

select cast(@rn := @rn+1 as integer) as ROWNUM

      ,table_schema, table_name

  from information_schema.tables, (select @rn:=0) as r1;