Re: 10MB Insert Issue

[Bill Karwin]

Does your text file contain any single-quote or apostrophe characters? It's probably causing a problem with unmatched quotes.

I'd use a parameterized query:

my $sth = $dbh->prepare("INSERT INTO myTable VALUES (1, 123, 'abc', ?)");
my $file_contents = join('', (<FILEHANDLE>));
$sth->execute($file_contents);

Regards,
Bill K.