When scraping a website, typically the majority of time is spent waiting for the data to download
So to be efficient I work on multiple scraping projects simultaneously.
Sometimes I need to import large spreadsheets into MySQL
The easy way would be to assume all fields are varchar, but then the database would lose features such as ordering by a numeric field.
The hard way would be to manually determine the type of each field to define the schema.