Re: Importing files with perl::dbi

[httptech]

use DBI;

my $dsn = "DBI:mysql:foobar";
my $user = "foobar";
my $pass = "baz";
my $textfile = "testing.txt";

open (TEXT, "$textfile") or die "Couldn't open textfile: $!";
$dbh = DBI->connect($dsn, $user, $pass,{ RaiseError => 1})
   or die "Could not connect to database! $DBI::errstr";
{ 
  local $/ = undef; 
  $dbh->do("INSERT INTO foo (bar) values (?)", undef, <TEXT>);
}
$dbh->disconnect;
close TEXT;