Re: perl and mysql parse a text file

[VSarkiss]

in reply to perl and mysql parse a text file

Fletch's answer above is a good way to go. If you need the rows in an array for some other reason, you can always join them before you insert, something like this:

@array = <IN>;
# Other stuff with @array ...
$sth = $dbh->prepare('insert into data_profile (file) values (?)');
$sth->execute(join '' => @array);