awohld has asked for the
wisdom of the Perl Monks concerning the following question:
I have a CSV data file that I get every day where the column headings can change without notice.
I want to delete my old table and create a new table every day that has the same column names as my CSV file.
Are there any modules or code snippets that can CREATE a MySQL table from the the CSV file formant?
Right now I'm looking at using Text::CSV_XS to get the column names for the CREATE TABLE statement, but I'm having trouble building the SQL statment dynamically from the file. Any help is apprecieated.