I have a mysql query producing more than 200k records. I want to export them all to excel sheet. This should be done within seconds.
select location as Location, date as Date, population as Population, total_cases as InfectionCount,
total_cases / population * 100 as PercentPopulationInfected
from coviddeaths
where continent is not null
order by 1, 2
I tried this query and ui of mysql, but it is not responding while transporting records.