in reply to MySQL: trouble inserting an array with some undefined members into a table using a set number of placeholders

I usually employ MySQL's very own LOAD DATA LOCAL INFILE when loading a CSV file:

LOAD DATA LOCAL INFILE 'gleandata.csv' INTO TABLE as_contacts FIELDS T
+ERMINATED BY ":" OPTIONALLY ENCLOSED BY """" LINES TERMINATED BY "\r\
+n";

[download]

Unless I'm missing something...

—Brad
"The important work of moving the world forward does not wait to be done by perfect men." George Eliot
  • Comment on Re: MySQL: trouble inserting an array with some undefined members into a table using a set number of placeholders
  • Select or Download Code

In Section Seekers of Perl Wisdom