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.