|Keep It Simple, Stupid|
Creating Table and Inserting Data from CSVby awohld (Hermit)
|on Oct 04, 2005 at 18:50 UTC||Need Help??|
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.