Re: Creating Table and Inserting Data from CSV

[sk]

Thanks xorl! Sorry awolhd, I should have read it carefully.

NOTE: non-Perl solution

Wouldn't this do?

mysql> LOAD DATA INFILE 'data.csv' FIELDS TERMINATED BY ',' INTO TABLE
+ MYTABLE;

you need to drop your previous table

-SK

[xorl]

That would work fine if the table alreay existed. I think he wants to create a table first. In which case you somehow have to figure out the create table statement first. Once the table is created, like I said above, we both agree he should use load data infile

I'd like to know exactly what he is doing. It seems odd that he'd have a csv file where the column order and column names changes randomly.

[awohld]

It is odd, but I'm taking a dump of settings that change regularly with new software loads.

[awohld]

When I try that it says the table doesn't exist, I want the program to create the table every time. As far as my understanding you need an existing table to do LOAD DATA INFILE.