in reply to Creating Table and Inserting Data from CSV
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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Creating Table and Inserting Data from CSV
by xorl (Deacon) on Oct 04, 2005 at 19:22 UTC | |
by awohld (Hermit) on Oct 04, 2005 at 19:35 UTC | |
Re^2: Creating Table and Inserting Data from CSV
by awohld (Hermit) on Oct 04, 2005 at 19:19 UTC |
In Section
Seekers of Perl Wisdom