Como usar parecido com o row_number(SQL SERVER) NO MYSQL?
EX.
SELECT
(row_number() over (order by base)) AS ID,
substring(base,1,7) as Nome,
substring(base,8,2) as TipoDoRegistro,
substring(base,10,20) as Matrícula,
substring(base,30,70) as Plano,
substring(base,100,22)as NumeroDoCartao,
substring(base,122,2)+'/'+substring(base,124,2)+'/'+substring(base,126,4)as DataNascimento,
substring(base,130,96) as Boleto,
substring(base,226,10)as ValorTotalMensalidades,
substring(base,236,2)+'/'+substring(base,238,2)+'/'+substring(base,240,4)as DataLimitePagamento,
substring(base,244,10)as Sequencial,
substring(base,254,20)as ChaveOrigemRotina
FROM (
SELECT ROW_NUMBER() OVER(ORDER BY base) id, base FROM dbo.testebase
) TAB WHERE id % 2 > 0
ORDER BY id
