go ahead... be a heretic | |
PerlMonks |
Perl DBI and mySQLby jperlq (Acolyte) |
on Feb 02, 2008 at 19:31 UTC ( [id://665761]=perlquestion: print w/replies, xml ) | Need Help?? |
jperlq has asked for the wisdom of the Perl Monks concerning the following question:
Hi PerlMonks,
A quick question for those of you familiar with Perl DBI module. The basics of the code is pulling a table out of an obsolete database and putting it into a new mySQL database. I'm approaching this using a set of arrays -- basically, pulling one row at a time from the old table and putting it into the new & linking it with the column names. when I check the lenght of the arrays of both @col and @values in perl -- the result is the same: the number of columns is 10; the number of values is 10, however when I join the columns and values into strings "," deliminated, and try to INSERT the row into the database, I get a error: DBD::mysql::db do failed: Column count doesn't match value count here's the code snippet: There is some strange syntax in the old table to begin with, a column including both ";" and "." could this choking the mySQL?
many thanks,
Back to
Seekers of Perl Wisdom
|
|