in reply to perl and mysql parse a text file

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.