Re: perl and mysql parse a text file

[idle]

Assuming that you use DBI, the code should look like this:

my $sth=$dbh->prepare("INSERT INTO data_profile VALUES (?)");
while(<DATA>){
   $sth->execute($_)or die $dbh->errstr;
}
__DATA__
1   10
2   20

Check the docs on DBI.