Re: perl and mysql parse a text file

[rnahi]

in reply to perl and mysql parse a text file

If your query requires one parameter, and you are passing an array, it's correct that only the first is inserted.

What you need is to prepare once aand execute many times.

my $sth = $dbh->prepare( "INSERT INTO data_profile (file) VALUES (?)")
+;
for (@array) {
    $sth->execute($_);
}

Alternatively, you can create a multiple insert query.

# assume that @array contains qw(abc def ghi);
my $query = 'INSERT INTO data_profile (file) VALUES ';
$query .= join(',', map {'(?)'} @array);

# now $query will be 'INSERT INTO data_profile (file) VALUES (?),(?),(
+?)'
$dbh->do($query, @array);

HTH

[Anonymous Monk]

this would create a separate DB row for each file row? Is it possible to store the entire file in a single row?

[rnahi]

Well, if you say "parse" a text file and then use an "@array", it seemed logical to assume that you wanted separate records.

With this new piece of information at hand, Fletch's post meets your needs.

I recommend you read this useful node and this insightful article (off site) before you post your next request.