I'm seeking to find a way to generate a new MySQL table solely based on the contents of a specified CSV. The CSV files I'll be using have the following properties;
- "|" delimited.
- First row specifies the column names (headers), also "|" delimited.
- Column names & order are not fixed.
- The number of columns is not fixed.
- Files are of a large size (1 mil rows / 50 columns).
In Excel this is all rather simple, however with MySQL it does not appear to be (no luck with Google). Any suggestions on what I should be looking at?