select count(*) as totalRows from myTable;

select 'Name' as name, 'class' as class union
select name, class from myTable limit 100000 offset $calculatedOffset
into outfile ..... as per your requirement